How do I get the "&" to show in a name in a header in Excel?

D

dancinbran

I am trying to get a company name to show up in a custom header, but the & is
used for formatting and so it doesn't show up in the header. A & A Produce
looks like A A Produce. Any ideas? I tried putting an apostrophe in front of
the text, but that only seems to work inside the cells. I am using Office
Excel 2003. Thanks!
 
E

EricG

You probably just need to you two ampersands - "Jones && Company" should work.

HTH,

Eric
 
×

מיכ×ל (מיקי) ×בידן

Try entering: A && A Produce rather than: A & A Produce.
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Skipping the first row in a repeated header 0
Insert name and adress from a list in a word document 1
Doughnut Chart linked with the slicer in the pivot table 0
Outlook meeting location auto prompts with a suggestion list - need to disable 0
Create a chart from a table in word thats dynamic 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Need help finding old, outdated contacts in Outlook 365 on my PC 0
How to display the merge function "url" of a picture? 0

Top