And when you get really frustrated...

That never happens, does it?

Biff

"Dave Peterson" wrote in message
...
And when you get really frustrated...

=A1&CHAR(34)&B1&CHAR(34)



SteveFox wrote:

I have AAA in cell A1 and BBB in cell B1 and I want to use the
concatenate function to output the below in cell C1 but I having
trouble printing double quotes ".

AAA"BBB"

Could someone please tell me the escape charater to do this?

--
SteveFox
------------------------------------------------------------------------
SteveFox's Profile:
http://www.excelforum.com/member.php...o&userid=28975
View this thread:
http://www.excelforum.com/showthread...hreadid=495718

--

Dave Peterson