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.