Excel 2007 : adding text to string

[kevnpaige]

Hello!
I have 2 columns of cells with hundreds of rows. One column contains the name of a picture file, and the other column contains a string that points to the location of that picture. The path is the same on every row. The only difference is the name of the picture.
How can I change only the part of the text string in column 2 that shows the picture name, to read from the cell in the first column?

example:

Column1
sample_pic.gif

Column2
c:\workspace\images\sample_pic.gif


Any help would be much appreciated.
Thanks!

[arthurbr]

Your link yields an error please attach a sample file - Edit your post - click go advanced - click the paperclip and follow the instructions

[kevnpaige]

The link was just there as a sample file location. Didn't mean for it to be clicked.
Sorry

[pizjuk]

I have a suggestion, try and see if this works.

The solution is based on this cell referencing:
Cell A1: Conatins name of file
Cell B1: Contains the path of the file + name of the file (from cell A1)

Please Login or Register  to view this content.

Once you have entered the formula in cell B1, drag it down.

Hope that helps.