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.