ExcelBanter - Excel 2003 and 2007

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

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

- - Excel 2003 and 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/239213-excel-2003-2007-a.html)

Renee

Excel 2003 and 2007

When typing in a custom header the "&" sign will not show up. For
example:

"Smith & Jones" will come out as "Smith Jones". Is there a way around this?

Per Jessen

Excel 2003 and 2007

Hi

Use two & signs:

Smith && Jones

Regards,
Per

"RENEE" skrev i meddelelsen
...
When typing in a custom header the "&" sign will not show up. For
example:

"Smith & Jones" will come out as "Smith Jones". Is there a way around
this?

Renee

Excel 2003 and 2007

Thank you - worked like a charm!

"RENEE" wrote:

When typing in a custom header the "&" sign will not show up. For
example:

"Smith & Jones" will come out as "Smith Jones". Is there a way around this?

All times are GMT +1. The time now is 05:08 PM.