Excel 2003 help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In B1 enter ="NFL Full Size Helmets" & A1 & ".jpg"

Then copy and in place Paste Special>Value>OK>Esc.

I assume you would then make it a hyperlink.


To remove blank rows..........

Select column A and F5>Special>Blanks>OK

Edit>Delete>Entire Row.

Gord Dibben Excel MVP
 
YOU'RE AWESOME!!!! thanks......HUGE timesaver

Gord Dibben said:
In B1 enter ="NFL Full Size Helmets" & A1 & ".jpg"

Then copy and in place Paste Special>Value>OK>Esc.

I assume you would then make it a hyperlink.


To remove blank rows..........

Select column A and F5>Special>Blanks>OK

Edit>Delete>Entire Row.

Gord Dibben Excel MVP
 
Back
Top