How do i use the "&" symbol in a header in excel?

[Guest]

Is there a way to use the "&" symbol in a header in excel?

Excel uses that symbol as part of its page no. etc header/footer references,
and simply ignores it when simply typed in.

Thanks

 

[Zygan]

just double the and && sig

 

[Guest]

Is there a way to use the "&" symbol in a header in excel?
Excel uses that symbol as part of its page no. etc header/footer references,
and simply ignores it when simply typed in.

Make it a double, eg type: Peter && Max
for it to show in the header as: Peter & Max
Let Excel swallow the first "&"

---

 

[Guest]

Is there a way to use the "&" symbol in a header in excel?
Excel uses that symbol as part of its page no. etc header/footer references,
and simply ignores it when simply typed in.

Make it a double, eg type: Peter && Max
for it to show in the header as: Peter & Max
Let Excel swallow the first "&"

---