Make a word formula
 

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.

Make a word formula
 

="<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
--
paul
remove nospam for email addy!



"Chopper" wrote:

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.

Make a word formula
 

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

"paul" wrote:

="<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
--
paul
remove nospam for email addy!



"Chopper" wrote:

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.

Make a word formula
 

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

--
paul
remove nospam for email addy!



"Chopper" wrote:

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

"paul" wrote:

="<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
--
paul
remove nospam for email addy!



"Chopper" wrote:

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.

Make a word formula
 

It didn't work... there is an error between ="<a and href=" What do you think?

"paul" wrote:

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

--
paul
remove nospam for email addy!



"Chopper" wrote:

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

"paul" wrote:

="<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
--
paul
remove nospam for email addy!



"Chopper" wrote:

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.

Make a word formula
 

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

"Chopper" wrote in message
...
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.

Make a word formula
 

That got it to work, thanks.

"Biff" wrote:

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

"Chopper" wrote in message
...
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.

Make a word formula
 

You're welcome!

Biff

"Chopper" wrote in message
...
That got it to work, thanks.

"Biff" wrote:

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

"Chopper" wrote in message
...
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.