Formula for file location

S

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top