How to do an ampersand in excel header and footer

[ExcelNewbie]

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

Can anyone help me.

Shauna

 

[Chip Pearson]

Shauna,

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



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

 

[Ken Macksey]

Hi

I beleive you have to use 2 like this &&

HTH

Ken

 

[ExcelNewbie]

THanks folks

the && worked great