Hi,

How about some helper columns.

For Pic try

="images/gl"&2000&ROW(B1)&".jpg"

For 2nd Column try

=LEFT(A1,5)&TEXT(ROW(),"dd")&RIGHT(A1,3)

Two different ways. Play with every one best fits your needs

VBA Noob