Copying Text from 1 cell and inserting into the text of another

Hi,

I am creating a file for mailmerge purposes and I'm hoping this will save a lot of typing.

I have a column of file names and then in the adjacent column I want to have where the file is located so that they file can be sent as an attachment through Word mailmerge.

EG:

File Location
ADD10001 C:\my documents\ADD10001.doc
ADD10002 C:\my documents\ADD10002.doc

I can't just drag the column down like when I created the file names to continue the sequence because of the .doc at the end.

Is there a way that I can have the location column pull the info from the file column into the correct area - C:\my documents\"A2".doc (I know that doesn't work but it was to give an idea)

Hope someone can help as at the moment I have had to resort to typing .doc at the end of each line (and I'm hoping to be able to do this for around 400 records!)

Derek

Like this:

="C:\my documents\"&A2&".doc"

Dom