Can I Create Hyperlink using Concatenate???

**weavejo1** · 10-09-2006, 08:34 AM

I have a sheet that lists part numbers in one column. Next to it I would like to create a hyperlink to a web address that is the image for that part number. All of the images are at the same web address so everythink is identical except for the part including the part number. for example the address for the first item is http://www.website.com/images/products/1-4.jpg Can I use concatenate or some other function to create the hyperlink column using the part numbers from another column??? and then populate the whole column automatically. (The are over 7000 items in the part column)

Thanks,

John

Part No
1-4
1-200
1-202
1-208
1-210
1-211
1-212
1-213
1-214
1-220
1-221-A
1-221-SM
1-222
1-226

**davesexcel** · 10-09-2006, 08:55 AM

Try this
="http://www.website.com/images/products/"&A1
="http://www.website.com/images/products/"&A2
="http://www.website.com/images/products/"&A3
="http://www.website.com/images/products/"&A4
="http://www.website.com/images/products/"&A5
="http://www.website.com/images/products/"&A6
="http://www.website.com/images/products/"&A7
="http://www.website.com/images/products/"&A8
="http://www.website.com/images/products/"&A9
="http://www.website.com/images/products/"&A10
="http://www.website.com/images/products/"&A11
="http://www.website.com/images/products/"&A12
="http://www.website.com/images/products/"&A13
="http://www.website.com/images/products/"&A14

here are a few links with a lot of info on hyperlinks

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
http://peltiertech.com/Excel/Hyperlinks.html
http://exceltips.vitalnews.com/Pages..._in_Excel.html