Escape character for double quotes

S

SteveFox

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


AAA"BBB"


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

Biff

Hi!

Try this:

=A1&""""&B1&""""

That's 4 double quotes on each side if it's had to distinguish.

Biff
 
Top