Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put special symbols like "&" in my Excel header?
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put special symbols like "&" in my Excel header?
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 "M" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put special character "&" in Excel Header / Footer ? | Excel Discussion (Misc queries) | |||
Why would "paste special" disappear as an option in Excel | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how to copy a pivot table and "paste special" formats in excel 07 | Excel Discussion (Misc queries) | |||
Use of "&" in Header name ex. "CS&T" comes back CS&[Time]? | Excel Discussion (Misc queries) |