CONCATENATE text that includes quotation marks

[spoonpilot]

Hi,

I am trying to use excel (2003) to create html code.
Within the html code there are a href links. These each require 2 quotation marks " for example
<A href="http://www.imdb.com/find?s=all&amp;q=Doris Day">IMDB

I can get excel to accept a formula to create the above links without the quotation marks, but they do not work properly because the link is only recognised to the point where there is a space, so above between Doris and Day. Therefore the link search searches only for Doris

My working formula which does not include the extra quotation marks is below

=CONCATENATE("<P> Find out more about ",C3," ",D3," via these direct links <BR> <A href=",W3," >IMDB</A>&nbsp; &nbsp;<A href=",X3," >Wikipedia</A>&nbsp; &nbsp;<A href=",Y3," >Google</A></P>")

however, to obtain the text result I am looking for i need an extra " after <A href=", and an extra " before >Wikipedia - so it should read like this <A href="",W3," ">IMDB</A>

Unfortunately excel does not like the extra quotations in the above example, and I have tried as many things as I can think of to amend it, but to no avail.

I should mention also that I have got excel to accept a formula using what seems to be a slightly different quotation mark, though I dont really know what the differences are.
The one created in the excel formula is a vertical mark, but there is another type that is slightly slanted. Although using these second types of marks is accepted by the formula, when pasted into an HTML editor, the links do not work as they try to point to a (non-existent) file on C Drive and not to a location on the internet.

If anybody knows a work around for this, I would be most grateful if you could share it with me!

Very many thanks., Andy

[Marcol]

Try using Char(34)
e.g.

Please Login or Register  to view this content.

[spoonpilot]

Thanks very much for the quick reply.
Sorry to be a bit of a Noob, but I cant get it to work, For
<A href=",W3," >IMDB</A>
I have used
<A href=&CHAR(34)& ",W3," &CHAR(34)&>IMDB

but that just returns

<A href=&CHAR(34)&http://www.imdb.com/find?s=all&q=Doris Day &CHAR(34)&>IMDB

I assume I have put the 34 in the wrong place, but would have thought it right to keep the original quotes around the cell reference?

Thanks again

[spoonpilot]

ok, i was maybe being slow, but not too experienced with excel! The 34 thing worked, I just didnt know how to format it properly and didnt realise I needed to put that also in quotes!
The correct solution (in my case) was
<A href="&CHAR(34)&"",W4,""&CHAR(34)&">IMDB</A>

Thanks again for the pointer