Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate HTML containing double quotes
I am using Excel to build some repetitive html coding. I need to
concatenate html that contains double quotes ("), for example, I want to join the first line below: <td width="50%" valign="top" align="left" TO THIS: style="border-left-style: none; border-left-width: medium" How do I indicate to Excel that the double quotes are to be treated as text and not parts of the concatenation? Thanks for the assistance. Charlie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate HTML containing double quotes
I think you are using VBA code. Not sure since your question is very vaque.
If you are using WRITE in VBA change to PRINT. If not, then give us more details. "Chas" wrote: I am using Excel to build some repetitive html coding. I need to concatenate html that contains double quotes ("), for example, I want to join the first line below: <td width="50%" valign="top" align="left" TO THIS: style="border-left-style: none; border-left-width: medium" How do I indicate to Excel that the double quotes are to be treated as text and not parts of the concatenation? Thanks for the assistance. Charlie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate HTML containing double quotes
Thanks for the reply.
I need this function to work: =Concatenate("<td vAlign="top"","width="16"") How do I format the double quotes in the text strings so that the Concatenate function interprets them as text and not as text string delimiters? "joel" wrote in message ... I think you are using VBA code. Not sure since your question is very vaque. If you are using WRITE in VBA change to PRINT. If not, then give us more details. "Chas" wrote: I am using Excel to build some repetitive html coding. I need to concatenate html that contains double quotes ("), for example, I want to join the first line below: <td width="50%" valign="top" align="left" TO THIS: style="border-left-style: none; border-left-width: medium" How do I indicate to Excel that the double quotes are to be treated as text and not parts of the concatenation? Thanks for the assistance. Charlie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate HTML containing double quotes
Maybe...
=CONCATENATE("<td vAlign=""top""",",width=""16""") or ="<td vAlign=""top""" & ",width=""16""" Double up your internal quotation marks. And I added a comma. Not sure if you wanted that. Chas wrote: Thanks for the reply. I need this function to work: =Concatenate("<td vAlign="top"","width="16"") How do I format the double quotes in the text strings so that the Concatenate function interprets them as text and not as text string delimiters? "joel" wrote in message ... I think you are using VBA code. Not sure since your question is very vaque. If you are using WRITE in VBA change to PRINT. If not, then give us more details. "Chas" wrote: I am using Excel to build some repetitive html coding. I need to concatenate html that contains double quotes ("), for example, I want to join the first line below: <td width="50%" valign="top" align="left" TO THIS: style="border-left-style: none; border-left-width: medium" How do I indicate to Excel that the double quotes are to be treated as text and not parts of the concatenation? Thanks for the assistance. Charlie -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate HTML containing double quotes
=CONCATENATE("<td vAlign=""top""","width=""16""")
"Chas" wrote: Thanks for the reply. I need this function to work: =Concatenate("<td vAlign="top"","width="16"") How do I format the double quotes in the text strings so that the Concatenate function interprets them as text and not as text string delimiters? "joel" wrote in message ... I think you are using VBA code. Not sure since your question is very vaque. If you are using WRITE in VBA change to PRINT. If not, then give us more details. "Chas" wrote: I am using Excel to build some repetitive html coding. I need to concatenate html that contains double quotes ("), for example, I want to join the first line below: <td width="50%" valign="top" align="left" TO THIS: style="border-left-style: none; border-left-width: medium" How do I indicate to Excel that the double quotes are to be treated as text and not parts of the concatenation? Thanks for the assistance. Charlie |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate HTML containing double quotes
Hi,
It would appear you need to use 4 quotation marks to get one to show up, so for example, if you wanted to write "hello" in a cell, you would need to use the following formula; =CONCATENATE("""","hello","""") That would return this; "hello" Hope that helps! Rob On Friday, April 03, 2009 11:50 PM Chas wrote: I am using Excel to build some repetitive html coding. I need to concatenate html that contains double quotes ("), for example, I want to join the first line below: <td width="50%" valign="top" align="left" TO THIS: style="border-left-style: none; border-left-width: medium" How do I indicate to Excel that the double quotes are to be treated as text and not parts of the concatenation? Thanks for the assistance. Charlie On Saturday, April 04, 2009 9:34 AM joe wrote: I think you are using VBA code. Not sure since your question is very vaque. If you are using WRITE in VBA change to PRINT. If not, then give us more details. "Chas" wrote: On Saturday, April 04, 2009 10:42 AM Chas wrote: Thanks for the reply. I need this function to work: =Concatenate("<td vAlign="top"","width="16"") How do I format the double quotes in the text strings so that the Concatenate function interprets them as text and not as text string delimiters? "joel" wrote in message ... On Saturday, April 04, 2009 11:49 AM Dave Peterson wrote: Maybe... =CONCATENATE("<td vAlign=""top""",",width=""16""") or ="<td vAlign=""top""" & ",width=""16""" Double up your internal quotation marks. And I added a comma. Not sure if you wanted that. Chas wrote: -- Dave Peterson On Saturday, April 04, 2009 11:58 AM joe wrote: =CONCATENATE("<td vAlign=""top""","width=""16""") "Chas" wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double Quotes | New Users to Excel | |||
Double Quotes | Excel Discussion (Misc queries) | |||
Concatenate function adding double quotes to both ends of results | Excel Worksheet Functions | |||
concatenate, char(10), and double quotes | Excel Discussion (Misc queries) | |||
Concatenate columns, separated by double quotes | Excel Worksheet Functions |