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.