Y not make it possible to use an ampersand (&) in a custom header

J

Jack Bacchus

For reasons not entirely obvious, Office will not allow the use of an
ampersand (&) in an Excel custom header in XP.

Why not?

Even with a preceding apostrophe, it disappears without a trace on the
finished product and the print preview with even the empty space black holed
as well.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...8-38104bbf4f5a&dg=microsoft.public.excel.misc
 
D

Desert Piranha

Jack said:
For reasons not entirely obvious, Office will not allow the use of an
ampersand (&) in an Excel custom header in XP.

Why not?

Even with a preceding apostrophe, it disappears without a trace on the
finished product and the print preview with even the empty space black
holed
as well.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://tinyurl.com/l3w5tHi Jack,
Click to expand...
I believe you have to put an ampersand on each side of the one you
want.
IE:
Hi &&& Hi Again

Result will be --> Hi & Hi Again
 
D

Dave Peterson

Use two of them:

AT&&T

The & is used in a few variables &Page, &pages, ... and needs to be doubled up
if you want to see just one.
 
D

Desert Piranha

Dave said:
Use two of them:

AT&&T

The & is used in a few variables &Page, &pages, ... and needs to b
doubled up
if you want to see just one.
Click to expand...
You are so correct. I have an extra one in my response.
Dave
 
Top