Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data from another cell, I think there are macros | Excel Discussion (Misc queries) | |||
Copying cell data | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Formula for copying data for every 8th cell | Setting up and Configuration of Excel | |||
sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions |