ExcelBanter - How do I get '&' to print within the Header of a Excel Worksheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get '&' to print within the Header of a Excel Worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/255781-how-do-i-get-print-within-header-excel-worksheet.html)

Denise M.

How do I get '&' to print within the Header of a Excel Worksheet?

I am having trouble getting the & to show up in the Header of an Excel
Spreadsheet. What am I doing wrong? For example: Smith & Smith

ExcelNut

How do I get '&' to print within the Header of a Excel Worksheet?

Use two ampersands. The first one gets eaten by Excel.

Francis Hayes (The Excel Addict)
http://www.TheExcelAddict.com

dlw

How do I get '&' to print within the Header of a Excel Workshe

mmmmmmmm ampersands....

"ExcelNut" wrote:

Use two ampersands. The first one gets eaten by Excel.

Francis Hayes (The Excel Addict)
http://www.TheExcelAddict.com
.

All times are GMT +1. The time now is 04:12 AM.