How to do an ampersand in excel header and footer

Thread view:

Thread rating:

ExcelNewbie - 29 Jun 2004 15:14 GMT

I can't seem to get an & in my excel header. It
disappears.

Can anyone help me.

Shauna

Chip Pearson - 29 Jun 2004 15:19 GMT

Shauna,

The & character is a special control character when used in
headers and footers. To get an & to display, use two, &&.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

> I can't seem to get an & in my excel header. It
> disappears.
>
> Can anyone help me.
>
> Shauna

Ken Macksey - 29 Jun 2004 15:19 GMT

Hi

I beleive you have to use 2 like this &&

HTH

Ken

ExcelNewbie - 29 Jun 2004 18:29 GMT

THanks folks

the && worked great

>-----Original Message-----
>I can't seem to get an & in my excel header. It
[quoted text clipped - 4 lines]
>Shauna
>.