Concatenate HTML containing double quotes

C

Chas

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
 
J

joel

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.
 
C

Chas

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top