Putting the "&" in a worksheet heading

D

Dodi

we have headings that use the symbol "&" in it. But when
you print the worksheeet the "&" is left out. How can we
get it to print correct.
Example: A & B Contracting will print A B Contracting
 
J

JE McGimpsey

Double it (it's an escape character in headers and footers):

A && B Contracting
 

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

Automated Glossary of Terms in a Document 4
Automation of scanned file storage based on content 0
VBA to look for more than 1 key word and highlights 8
Incorporating the User Profile location into a document template path 1
White space above heading inconsistently applied 1
Shift Collate sheet 1-20 when printing entire workbook? 0
Images are pixelated when saving to PDF 0
Address Format changed after Migration 0

Top