Header Footer Field Codes

A

Alice

We cannot use the ampersand symbol in the header/footer as part of our company name because Excel sees this as an operator in a field code (I assume). Is there a way we can display the ampersand symbol (for example, enclose it in quotes or brackets) so that it will print in the header/footer?
 
C

Chip Pearson

Alice,

Use two ampersands && to display a single ampersand in the header
or footer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Alice said:
We cannot use the ampersand symbol in the header/footer as part
Click to expand...
of our company name because Excel sees this as an operator in a
field code (I assume). Is there a way we can display the
ampersand symbol (for example, enclose it in quotes or brackets)
so that it will print in the header/footer?
 

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

Page numbering with Merged Document and IF statements 1
Office 365 documents default header 1
How do I get "&" to print in the Header or Footer in Excel 1
Print without header & footer but keep spacing 3
Manipulate Headers/Footer in new Sections 0
Filepath/filename in header/footer, yes - how to put in table cell? 6
Change Header/Footer w/ Worksheet Option Buttons 1
Change Header & Footer Info w/ Worksheet Option Buttons 1

Top