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&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> <A href=",X3," >Wikipedia</A> <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
Bookmarks