Quotes within concatenation

[cjconnor24]

Hi all,

Trying to use quotes in a concatenation formula but they keep kicking everything out. In scripting languages, you can use a \ which basically stops the quote being treated in the typical way and treats it as a character.

Does anyone know of a way round this in excel?

eg.
=CONCATENATE("Chris "The Tester" Connor"," is testing this")

i know i could put "The Tester" in another cell and just reference that in the formula but i want to have everything contained within that one formula.

Thanks in advance!
Chris

[daddylonglegs]

You need to double up the literal quotes like

=CONCATENATE("Chris ""The Tester"" Connor"," is testing this")

[cjconnor24]

THat's great, thanks!