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

try
A&&B



Christina_0123 wrote:

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

Use a double ampersand

&&

--

HTH

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


"Christina_0123" wrote in message
...
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

Christina

Double up on the &

A&&B


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 08:36:22 -0800, "Christina_0123"
wrote:

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