Gary,
You can do this using a separate column and the & sign.
In column E type in the formula:
="http://www.mywebsite.com/images"&"/"&A2&"-FULL.jpg"
I used 123 for the Product Code in column A.
This results in:
http://www.mywebsite.com/images/123-FULL.jpg
You can then drag that down for all product codes. If you want to
create actual links, copy column E and use Paste Special - Values in
column D. This creates text that when you double click on it it
changes to a link. There may be an easier way to change all the values
at once in column D but I am not sure.
If you are not creating links and just need the value to appear in
column D, just type the formula in column D and drag down.
Hopefully this helps.
Cheers,
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=480838