Hi!
Try this:
=A1&""""&B1&""""
That's 4 double quotes on each side if it's had to distinguish.
Biff
"SteveFox" wrote in
message ...
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