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