garysumpter Wrote:
Hi all,

If you can help me out you will save me literally weeks / months of
work.

Basically I am creating a products reviews website and the largest
wholesaler of this market area has given me an excel spreadsheet of
around 6,000 products, along with html description and product code.

They have also given me (seperately) a directory of images.

The images are named PRODUCTCODE-FULL.jpg (the same product code as is
in the spreadsheet).

I will be importing the whole file into my websites database and I
REALLY need to get a column into the spreadsheet for images.

So, the spreadsheet currently has three colums

A - Product Code
B - Product Name
C - Product HTML description

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.

Is this at all possible?

Thanks very much

Gary

Hi Gary

In Cell D? try this ="http://www.mywebsite.com/images"&A?&"-Full.jpg"

where ? needs to be changed to the relevant row number


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480838