How can you add an "&" in a footer?

[Guest]

I'd like to add text in my footer that has an ampersand, but when I do, it
adds a page number instead. I'd like the footer to read: A&B Is there a
formula that will work? I've tried this:

A&" & "&B

 

[Dave Peterson]

try
A&&B

I'd like to add text in my footer that has an ampersand, but when I do, it
adds a page number instead. I'd like the footer to read: A&B Is there a
formula that will work? I've tried this:

A&" & "&B

 

[Bob Phillips]

Use a double ampersand

&&

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Christina

Double up on the &

A&&B


Gord Dibben Excel MVP