Hi Garysumpter,

IDEALLY, what I need is to have column D which somehow adds
http://www.mywebsite.com/images at the front, then pulls in the content
of cell A in that row, then adds -FULL.jpg directly after. This would
obviously create a url of the image.

="http://www.mywebsite.com/images" & "A1 & "-FULL.jpg"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com