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


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

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

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

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

you are a GEM! Thanks ever so much, im off to do it now!

Thanks again!


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