Can excel take content from another cell and add information either side??

[garysumpter]

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

 

[Jan Karel Pieterse]

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

 

[Paul Sheppard]

Hi all,

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

Basically I am creating a products reviews website and the larges
wholesaler of this market area has given me an excel spreadsheet o
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 i
in the spreadsheet).

I will be importing the whole file into my websites database and
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 add
http://www.mywebsite.com/images at the front, then pulls in the conten
of cell A in that row, then adds -FULL.jpg directly after. This woul
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 numbe

 

[SteveG]

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 t
create actual links, copy column E and use Paste Special - Values i
column D. This creates text that when you double click on it i
changes to a link. There may be an easier way to change all the value
at once in column D but I am not sure.

If you are not creating links and just need the value to appear i
column D, just type the formula in column D and drag down.

Hopefully this helps.

Cheers,
Stev

 

[garysumpter]

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

Thanks again!