| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct formula too long, & how to use make an 'OR' statement w | Excel Worksheet Functions | |||
| Can you use a formula to make a truly "blank" cell | Excel Worksheet Functions | |||
| How do I make this formula? | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
