How can I put special symbols like "&" in my Excel header?

  • Thread starter Thread starter M
  • Start date Start date
M

M

My department name uses the "&" symbol and when I type this in the Excel
headers, it simply deletes all text after that. I understand that it's
probably seeing it as an instructional symbol (but what would that do?), but
how do I override that to just have it see it as text?

I've gotten around this by just making clip art of the name and pasting it
in, but it'd be so much easier to just type it!
 
To override the special characters in excel, just type them twice. So, to
get "A&B Company". You'd type "A&&B Company".

HTH
Elkar
 

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

How do i use the "&" symbol in a header in excel? 3
Special Symbols in Excel 2000 3
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal 2
How do I eliminate a symbol? 1
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show 4
How do I change default symbols in Excel 2007? 2
How to put '&' sign in header text ??? 5
How to make a cents symbol in Excel 2007 6

Back
Top