Excel help required

[chris ashdown]

Afternoon all

in Excel i have a list of reference numbers and a list of image file locations i.e.

refno Location
34 C:\images
46 C:\images

I need to join the two together and add .jpg to the result so i get two columns

Ref No Location
34 C:\Images\34.jpg

Ref no can be up to 7 caracters

[jont]

A1 = image name
A2 = Path

in A3 add

.jpg

in A4 use

=A2&"\"&A1&A3

to give C:\image\name.jpg

or you can use &".jpg" instead of entering it in A3