Formula for file location

[soundsalarming]

Hi (I'm a newbie so please be patient)

I am using excel to build a database for an online store, i have apro
3000 products and each product needs an image path (eg. D:/m
docs/images/123.gif).

I need a formula that will automatically insert the path to the image
in its cell in the image colomn.

To make this easier all the image names are the the part number[.gif
so the image for product 123 is D:/my docs/images.123.gif.

Can any one offer a formula to do this?


Code
-------------------
Example of spread sheet
--------------------------------------------------

Make Model part number image
Brodit Clip 1234 D:/my docs/images/1234.gif

-------------------


All the images are in the same folder and they are all .gif files.

I hope this makes sense

 

[Frank Kabel]

Hi,

for your example (starting in D2 for the filename) enter the following
formula in D2:
="D:/mydocs/images." & C2 & ".gif"
just copy this formula for all your rows in D

HTH
Frank

 

[soundsalarming]

Thank you Frank, Worked a treat.

 

[Frank Kabel]

you are welcome
Regards
Frank