How to do an ampersand in excel header and footer

E

ExcelNewbie

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

Can anyone help me.

Shauna
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Separate lines (line break) - PowerPoint Footer 1
How to put an ampersand in an excel header and footer? 4
Why does the ampersand symbol disappear when typed in a header? 4
Ampersand in Header 1
Excel Footer Dilemma 1
How can I keep "&" in the header? 2
how do I get rid of header/footer on page 2 of document? 4
No More New Fonts May Be Applied To This Work Book 2

Top