View Single Post
  #1   Report Post  
Excel Distress
 
Posts: n/a
Default How do I concatenate text that actually contains quotation marks?

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!)