| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"&" in Custom Header
If I put an "&" in the Custom Header, it behaves very weird. For some reason,
it does not like "&". For example, if I make my Custom Header... D&B Information It will actually end up reading... Information<Left Margin D<Centered Its almost as though it treats the "&" to break the Custom Header at that point and move everything after the "&" to the Left margin. Has anyone ever seen this??? Is their a work around besides the obvious of NOT using "&" in the Custom Header??? Your feedback is GREATLY appreciated and Thanks in Advance for your help. PSULionRP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"&" in Custom Header
To get A & B
try A && B "PSULionRP" wrote: If I put an "&" in the Custom Header, it behaves very weird. For some reason, it does not like "&". For example, if I make my Custom Header... D&B Information It will actually end up reading... Information<Left Margin D<Centered Its almost as though it treats the "&" to break the Custom Header at that point and move everything after the "&" to the Left margin. Has anyone ever seen this??? Is their a work around besides the obvious of NOT using "&" in the Custom Header??? Your feedback is GREATLY appreciated and Thanks in Advance for your help. PSULionRP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"&" in Custom Header
& is used as an escape character. To use it as text, try "D&&B". That
should work. HTH, Eric "PSULionRP" wrote: If I put an "&" in the Custom Header, it behaves very weird. For some reason, it does not like "&". For example, if I make my Custom Header... D&B Information It will actually end up reading... Information<Left Margin D<Centered Its almost as though it treats the "&" to break the Custom Header at that point and move everything after the "&" to the Left margin. Has anyone ever seen this??? Is their a work around besides the obvious of NOT using "&" in the Custom Header??? Your feedback is GREATLY appreciated and Thanks in Advance for your help. PSULionRP |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"&" in Custom Header
Hi
use D&&B If this was helpful please click yes. thanks "PSULionRP" wrote: If I put an "&" in the Custom Header, it behaves very weird. For some reason, it does not like "&". For example, if I make my Custom Header... D&B Information It will actually end up reading... Information<Left Margin D<Centered Its almost as though it treats the "&" to break the Custom Header at that point and move everything after the "&" to the Left margin. Has anyone ever seen this??? Is their a work around besides the obvious of NOT using "&" in the Custom Header??? Your feedback is GREATLY appreciated and Thanks in Advance for your help. PSULionRP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 can I use the ampersand in a custom header as the word "and"? | Excel Discussion (Misc queries) | |||
| How do I get the "&" to appear in a custom header? | Excel Discussion (Misc queries) | |||
| Use of "&" in Header name ex. "CS&T" comes back CS&[Time]? | Excel Discussion (Misc queries) | |||
| How do I get rid of "Top 10" and "Custom" choices Autofilter? | Excel Worksheet Functions | |||
Linear Mode
