Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create an excel macro to append to a cell with existing i
How do I create an excel macro to append data to a cell with existing data?
example one row has rs1006 and I want it to read rs1006.jpg there are 5000 records in each one of my sheets is why I am looking for a macro. |
#2
|
|||
|
|||
Zola: You can prolly do this, much more quickly: insert a column and type
the following formula (change A1 to the cell in which your first product number resides): =a1&".jpg" Copy it down using the Fill Handle: http://www.officearticles.com/excel/...soft_excel.htm Leaving all the cells selected, hit Copy, then immediately hit Edit--Paste special--Values. Delete the original column. ************ Anne Troy www.OfficeArticles.com "zola_tiara" wrote in message ... How do I create an excel macro to append data to a cell with existing data? example one row has rs1006 and I want it to read rs1006.jpg there are 5000 records in each one of my sheets is why I am looking for a macro. |
#3
|
|||
|
|||
If i'm reading you right you can just use the CONCATENATE() function and drag
down, you don't need a macro. If A1 had the value 'John' and A2 had the value 'Smith': =CONCATENATE(A1," ",A2) will output "John Smith" -- Regards, Dave <!-- "zola_tiara" wrote: How do I create an excel macro to append data to a cell with existing data? example one row has rs1006 and I want it to read rs1006.jpg there are 5000 records in each one of my sheets is why I am looking for a macro. |
#4
|
|||
|
|||
Thank you so much, this just shows there is so much more for me to learn
about Excel. Thanks again, what a help. Zola "Anne Troy" wrote: Zola: You can prolly do this, much more quickly: insert a column and type the following formula (change A1 to the cell in which your first product number resides): =a1&".jpg" Copy it down using the Fill Handle: http://www.officearticles.com/excel/...soft_excel.htm Leaving all the cells selected, hit Copy, then immediately hit Edit--Paste special--Values. Delete the original column. ************ Anne Troy www.OfficeArticles.com "zola_tiara" wrote in message ... How do I create an excel macro to append data to a cell with existing data? example one row has rs1006 and I want it to read rs1006.jpg there are 5000 records in each one of my sheets is why I am looking for a macro. |
#5
|
|||
|
|||
Thanks for the quick response and the valuable help. This will definately
make it much easier on me in manipulating these records. zola "David Billigmeier" wrote: If i'm reading you right you can just use the CONCATENATE() function and drag down, you don't need a macro. If A1 had the value 'John' and A2 had the value 'Smith': =CONCATENATE(A1," ",A2) will output "John Smith" -- Regards, Dave <!-- "zola_tiara" wrote: How do I create an excel macro to append data to a cell with existing data? example one row has rs1006 and I want it to read rs1006.jpg there are 5000 records in each one of my sheets is why I am looking for a macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
How do I create a macro, that references another excel file ??? | Excel Worksheet Functions | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |