how can I use the ampersand in a custom header as the word "and"?
 

When I type in an "&" in the center of my custom header, it takes the words
after that sign and moves them into the right cell. I would like to use the
sign rather than the word "and". Is this possible?

how can I use the ampersand in a custom header as the word "and"?
 

Use two ampersands as in "Fish && Chips"
Only one will display
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"pickle77" wrote in message
...
When I type in an "&" in the center of my custom header, it takes the
words
after that sign and moves them into the right cell. I would like to use
the
sign rather than the word "and". Is this possible?

how can I use the ampersand in a custom header as the word "and"?
 

What version of excel are you using. I tried to recreate what you were
talking about it was unsuccessful.

Maybe you could email me your file?



On Nov 9, 10:35 am, pickle77
wrote:
When I type in an "&" in the center of my custom header, it takes the words
after that sign and moves them into the right cell. I would like to use the
sign rather than the word "and". Is this possible?

how can I use the ampersand in a custom header as the word "an
 

Thanks a bunch! This worked great!

"Bernard Liengme" wrote:

Use two ampersands as in "Fish && Chips"
Only one will display
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"pickle77" wrote in message
...
When I type in an "&" in the center of my custom header, it takes the
words
after that sign and moves them into the right cell. I would like to use
the
sign rather than the word "and". Is this possible?

how can I use the ampersand in a custom header as the word "an
 

Excel 2003
I could email you the file to play with if you'd like. What's your address?

"Tim879" wrote:

What version of excel are you using. I tried to recreate what you were
talking about it was unsuccessful.

Maybe you could email me your file?



On Nov 9, 10:35 am, pickle77
wrote:
When I type in an "&" in the center of my custom header, it takes the words
after that sign and moves them into the right cell. I would like to use the
sign rather than the word "and". Is this possible?