=CONCATENATE("extvalue"&C1174&" """&D1174&""",")

--

HTH

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


"Excel Distress" <Excel wrote in message
...
I'm building tiresome SQL statements by concatenating text and cell
contents.
I need to be able to insert double quotation marks into the actual text
strings for concatenation. Excel won't allow this because to concatenate
the
strings themselves, they must be enclosed in double quotation marks.

Example: =CONCATENATE("extvalue"&C1174&" "&D1174&",") gives me
"extvalue211
Legal Name," when what I actually want is "extvalue211 "Legal Name"". (And
no, I don't want to rename all my SQL column headers to contain
underscores
and no spaces!)