| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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!) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| space between text strings with concatenate | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| concatenate text and date | Excel Discussion (Misc queries) | |||
| concatenate a text string if two different cells contain the sam. | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
