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.