Paul,
Goodness, I am an idiot.. I dont' use excel often for my business so I
appreciate the answer but not sure what it means. Do I need to make some
type of formula, as I have never done that before.
Brenda

"PCLIVE" wrote:

One way,

="http://www.needhelp.com/images/" & A1 & ".jpg"

If you want it to be an active hyperlink, then:

=HYPERLINK("http://www.needhelp.com/images/" & A1 & ".jpg")

Regards,
Paul


"BrendaB22" wrote in message
...
I am trying to make a file for my web designer. I have inventory numbers
and
need to put a path infront of the inventory numbers and .jpg on the end.
But
I can't figure out how to put that information in without having to paste
each row (once for the beginning information and once for the .jpg) and we
have over 10,000 products. Is there anyway to do this automatically or in
bulk
for instance. *** just an example *** the column going down now is 1 2 3
4 5
need to put have it as such: http://www.needhelp.com/images/1.jpg

so I need help so I don't spend all day pasting.
thanks so much
Brenda