ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I insert "&" in Header & Footer? (https://www.excelbanter.com/excel-discussion-misc-queries/47138-how-can-i-insert-%22-%22-header-footer.html)

Regina Man

How can I insert "&" in Header & Footer?
 
I'm using Excel 2003.
I've tried to incorporate "&" in the Header & Footer but without success.
I've also tried cut and paste "&" from symbol but it seems it cannot be
pasted in "Custom the Header & Footer".
Hope somebody can answer my question! Thanks!

William

Use 2 "&" for the footer to show one.

--


XL2003
Regards

William



"Regina Man" <Regina
wrote in message
...
I'm using Excel 2003.
I've tried to incorporate "&" in the Header & Footer but without success.
I've also tried cut and paste "&" from symbol but it seems it cannot be
pasted in "Custom the Header & Footer".
Hope somebody can answer my question! Thanks!




Chip Pearson

The & character is a special control character in headers and
footers. To put an & in the header or footer, use &&.


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



"Regina Man" <Regina wrote in
message
...
I'm using Excel 2003.
I've tried to incorporate "&" in the Header & Footer but
without success.
I've also tried cut and paste "&" from symbol but it seems it
cannot be
pasted in "Custom the Header & Footer".
Hope somebody can answer my question! Thanks!





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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com