Adding to the text in a range of cells.

[Frank Z]

I've got a spead sheet containg 10,000 parts in cells A2 through A10001

I need to break up these into smaller groups (1k each) by adding GRP1/, GRP2/, GRP3/, etc to the text that's already in the cells.

Is there a Function that will do this for me?

 

[Frank Z]

Reviving an old thread...

I've got a bunch of cells that I need to add .jpg to the end of the filename in those cells.

Anyone?