copying data to an adjacent cell
 

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.

If A1 contains ABC put

=A1&".jpg"
in cell B1 and copy on down
--
Gary''s Student


"Paul K." wrote:

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.

Thanks Gary, you are a Saint

"Gary''s Student" wrote:

If A1 contains ABC put

=A1&".jpg"
in cell B1 and copy on down
--
Gary''s Student


"Paul K." wrote:

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.