| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| How do I get the "&" to appear in a custom header? | Excel Discussion (Misc queries) | |||
| How do I display the "ampersand" in the header as text | Setting up and Configuration of Excel | |||
| Y not make it possible to use an ampersand (&) in a custom header | Excel Discussion (Misc queries) | |||
| Why isn't an 'ampersand' visable when inserted in a custom header. | Excel Discussion (Misc queries) | |||
Linear Mode
