Make a word formula

C

Chopper

I am attempting to make a database for advertiseing web forums. I want the
user to download the file, edit it and email it back to me. How here is the
part I have a question about. I want te people to put in the board URL and
their Mini Banner url and then excel make the code. The following is what I
am trying. ( l ) means start of new cell.

<a href=" l URL l "_blank"><img src=" l IMGURL l " alt=" l BOARDNAME l "
border="0"></a>

That would make "<a href="URL"_blank"><img src="IMGURL" alt="BOARDNAME"
border="0"></a>

Basicaly anything in CAPS is what the user inputs. What should I do, and is
there a better way to do it.
 
P

paul

="<a href="&URL&""_blank"><img
src=""&IMGURL""alt=""&BOARDNAME&""border="0"></a>"
be careful with The " a double one means there will be a " shown in the text
a single one makes the formula text The & symbol joins the seperate text
string into a single string
 
C

Chopper

It didn't work ="<a href=""&E8&""_blank"><img
src=""&F8&""alt=""&A8&""border="0"></a>"
 
P

paul

hmmm yes the double quotes thing is not consistent is it?I had more success
when i tried smaller bits.Try one small phrase at a time,for instance ="<a
href="""(triple quote at end) gives <a href=",and build it up in several cells
 
B

Biff

Try this:

="<a href="&""""&E8&""""&"_blank"&""""&"><img src="&""""&F8&""""&"
alt="&""""&A8&""""&" border="&""""&"0"&""""&"></a>"

Returns:

<a href="URL"_blank"><img src="IMGURL" alt="BOARDNAME" border="0"></a>

You sure you have the correct number of quotes? Seems to me that the one
after blank doesn't pair-up?

Biff
 
C

Chopper

That got it to work, thanks.

Biff said:
Try this:

="<a href="&""""&E8&""""&"_blank"&""""&"><img src="&""""&F8&""""&"
alt="&""""&A8&""""&" border="&""""&"0"&""""&"></a>"

Returns:

<a href="URL"_blank"><img src="IMGURL" alt="BOARDNAME" border="0"></a>

You sure you have the correct number of quotes? Seems to me that the one
after blank doesn't pair-up?

Biff
Click to expand...
 
Top