copying data to an adjacent cell

[Guest]

I have a huge list of products in Excel which have associated images. I have
changed all the image file names to reflect the product ID no for example:
product named abc and image file name abc.jpg.
Is it possible to configure excel to automatically attach the> .jpg file
extension to cells that have been copied and pasted from the product ID no.
I WANT TO COPY A CELL WITH ABC
AND PASTE ABC.jpg

At the moment I am keying in the file extension .jpg and I have a few
thousand products to do.

 

[Guest]

If A1 contains ABC put

=A1&".jpg"
in cell B1 and copy on down

 

[Guest]

Thanks Gary, you are a Saint

If A1 contains ABC put

=A1&".jpg"
in cell B1 and copy on down