Concatenate - Excel 2003 or 2007

  • Thread starter Thread starter Matteo
  • Start date Start date
M

Matteo

Dear all,
I have to concatenate some informations into a single line, these infos are
html code and javascript so sometimes I have characters like ' " ; using
them into the concatenate function they are interpret like interruptions or
break bu they are not, how can I solve it?

Thanks all

example:

<a href="#" onclick="getinfos(111); ">Try it</a>

Matteo
 
Place the problem characters in a cell of their own (eg. A1, B2, C3). Then
enter a formula using the & to concatenate those cells (ie =A1&B2&C3).
 
Dear all,
I have to concatenate some informations into a single line, these infos are
html code and javascript so sometimes I have characters like ' " ; using
them into the concatenate function they are interpret like interruptions or
break bu they are not, how can I solve it?

Thanks all

example:

<a href="#" onclick="getinfos(111); ">Try it</a>

Matteo
Click to expand...

Double the quote marks
--ron
 

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

Concatenate Funcion Excel 2003 or Excel 2007 1
Problem with Concatenate - Results are too long for CSV 4
Concatenating cells with ones that contain html tags and quotation marks? 1
Concatenate Multiple Cells into A Single Cell 2
Concatenating Rich Textbox Controls Into A Single File 10
Reading and writing UTF-8 files 8
When concatenating concatenates don't concatenate... 2
Consecutive Date Query 20

Back
Top