Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2003 help
Hi, I am using excel 2003 to import products onto my website. I have it set
up so that the product number corresponds with it's image. Could someone please tell me how to program a formula that allows me to: Add the text "NFL Full Size Helmets" before the value in A1, and ".jpg" after the value in A1. Also, could someone tell me how to quickly remove blank rows when you have a spreadsheet with info in only every third row? I've tried special pasting with the "skip spaces" option selected, but to no avail. Thanks -- „¢Â»ZrÃ¥xïûš« |
#2
|
|||
|
|||
In B1 enter ="NFL Full Size Helmets" & A1 & ".jpg"
Then copy and in place Paste SpecialValueOKEsc. I assume you would then make it a hyperlink. To remove blank rows.......... Select column A and F5SpecialBlanksOK EditDeleteEntire Row. Gord Dibben Excel MVP On Thu, 2 Dec 2004 11:19:10 -0800, "Zraxius" wrote: Hi, I am using excel 2003 to import products onto my website. I have it set up so that the product number corresponds with it's image. Could someone please tell me how to program a formula that allows me to: Add the text "NFL Full Size Helmets" before the value in A1, and ".jpg" after the value in A1. Also, could someone tell me how to quickly remove blank rows when you have a spreadsheet with info in only every third row? I've tried special pasting with the "skip spaces" option selected, but to no avail. Thanks |
#3
|
|||
|
|||
YOU'RE AWESOME!!!! thanks......HUGE timesaver
"Gord Dibben" wrote: In B1 enter ="NFL Full Size Helmets" & A1 & ".jpg" Then copy and in place Paste SpecialValueOKEsc. I assume you would then make it a hyperlink. To remove blank rows.......... Select column A and F5SpecialBlanksOK EditDeleteEntire Row. Gord Dibben Excel MVP On Thu, 2 Dec 2004 11:19:10 -0800, "Zraxius" wrote: Hi, I am using excel 2003 to import products onto my website. I have it set up so that the product number corresponds with it's image. Could someone please tell me how to program a formula that allows me to: Add the text "NFL Full Size Helmets" before the value in A1, and ".jpg" after the value in A1. Also, could someone tell me how to quickly remove blank rows when you have a spreadsheet with info in only every third row? I've tried special pasting with the "skip spaces" option selected, but to no avail. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) |