Concatenate Funcion Excel 2003 or Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matteo - 20 Dec 2007 11:29 GMT

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

Reply to this Message

Dave Peterson - 20 Dec 2007 12:03 GMT

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.

> Dear all,
> I have to concatenate some informations into a single line, these infos are
[quoted text clipped - 9 lines]
>
> Matteo

Signature

Dave Peterson

Reply to this Message

Rate this thread: