Excel – How to Get Ampersand to Print in Headers/Footers (Excel 2010/2007/2003)
When printing out worksheets in Excel, many people add a header and footer to print on each page as a finishing touch. Some characters will not print since Excel considers them a
command. One example of this is the ampersand. This will work the same in Excel 2003, Excel 2007 & Excel 2010