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!) |
#2
|
|||
|
|||
=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!) |
#3
|
|||
|
|||
In addition to Bob's suggestion, you can also use CHAR(34) to put double
quotes into a string I understand you don't want to change your column names, but the MVPs on the SQL Server newsgroup are VERY militant about that subject, indicating that using spaces in column names is contrary to best practice. "Excel Distress" wrote: 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!) |
#4
|
|||
|
|||
Thanks v much for all solutions. And now I have figured out I can put
underscores as well if I really want (per the SQL Server Police recommendation): =CONCATENATE("extvalue"&C1171&" "&SUBSTITUTE(D1171," ","_")&",") I'm good to go! "Duke Carey" wrote: In addition to Bob's suggestion, you can also use CHAR(34) to put double quotes into a string I understand you don't want to change your column names, but the MVPs on the SQL Server newsgroup are VERY militant about that subject, indicating that using spaces in column names is contrary to best practice. "Excel Distress" wrote: 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!) |
Reply |
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) |