how do I concatenate text that has a quotation mark

  • Thread starter Thread starter sparkroms
  • Start date Start date
S

sparkroms

how do I concatenate text that has a quotation mark in it like th
following html: <img width="76" height="25" src="blah"
 
I put 76 in A1, 25 in B1 and blah in C1.

Then I used this formula:

="<img width="""&A1&""" height="""&B1&""" src="""&C1&""">"

Seemed to match up ok.
 

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

Similar Threads

Concatenating cells with ones that contain html tags and quotation marks? 1
Quotation Marks as Text 2
Concatenation with Quotation Marks? 1
Quotation Marks 2
excel adds quotation marks when pasting text 6
Generating text surrounded by quotation marks 5
Single Quotation mark in CSV 1
CONCATENATE involving CHAR(13) and CHAR(10): "" marks when copy/pasteto text editor [???] 2

Back
Top