Need to create formula to generate an http path

Hello All,

We are working with an Excel 2007 Spreadsheet that has several thousand product SKU's in one column. We would like to, for each product sku put in a
http:// path for the image for the associated product sku; for example product sku: ASPF21B is in column A and we would like to fill in on column B
this, "http://www.mydomain.com/pics/ASPF21B_1.jpg". Note: each product sku has an associated image with the sku as the name with "_1.jpg" tacked
on to the end and the images are all stored in the same directory on our site. We would like to create a formula that would take the product sku name from
column A and fill in this, "http://www.mydomain.com/pics/productskuname_1.jpg" on column B using the product sku from column A to make the http path name. Your help is greatly appreciated.

gsmonk

Hello again,

Sorry but FrankBoston, I don't understand.

Thanks,

gsmonk

Thanks you very much for the help. That did the trick.

Thanks again,

gsmonk