Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
& in headers
I understand that if you want "M&A" to appear in a header you have to enter
it as M&&A What's the logic here? What would you be concatenating in the header (or footer)? -- Brevity is the soul of wit. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
& in headers
Dave,
The & symbol is a concatenation operator only in a formula. In a header, it's just another text character. But since the various codes, such as &[Page] all begin with that character, when Excel sees & in a header, it thinks a code is on the way. It could have been smart enough to interpret a single & as just that, an ampersand. But it isn't. We just have to remember this as one of the Excel oddies, and put && when we want &. This may be fixed in the year 2057, I'm told. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Dave F" wrote in message ... I understand that if you want "M&A" to appear in a header you have to enter it as M&&A What's the logic here? What would you be concatenating in the header (or footer)? -- Brevity is the soul of wit. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
& in headers
The logic is that for headers and footers, '&' is an escape character,
not a concatenation operator. For instance: Printed at &[Time] Will print the current time for &[Time] In article , Dave F wrote: I understand that if you want "M&A" to appear in a header you have to enter it as M&&A What's the logic here? What would you be concatenating in the header (or footer)? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
& in headers
Thanks.
-- Brevity is the soul of wit. "JE McGimpsey" wrote: The logic is that for headers and footers, '&' is an escape character, not a concatenation operator. For instance: Printed at &[Time] Will print the current time for &[Time] In article , Dave F wrote: I understand that if you want "M&A" to appear in a header you have to enter it as M&&A What's the logic here? What would you be concatenating in the header (or footer)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting by Column Headers | Excel Discussion (Misc queries) | |||
How to consolidate worksheets (1 file) with different headers? | Excel Worksheet Functions | |||
Excel - auto freeze list headers | Excel Worksheet Functions | |||
Headers on a Shared Workbook | Excel Discussion (Misc queries) | |||
Help with Headers | Excel Discussion (Misc queries) |