Concatenate Funcion Excel 2003 or Excel 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
 
You can surround the text with double quotes.

If you want to include double quotes, then use something like:

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

You double up each double quote inside a string.

There shouldn't be any trouble with the formula if you use single quotes or
semicolons inside the strings.
 
Back
Top