Forum Discussion
Automatically Add Numbers
I use Excel on a daily basis to count the number of court files per year. I have been adding them in manually and was wondering if there's a way to automatically have them added in columns. I have at...
As variant you may use formula like here
which is
=LEFT(D2,5)&(RIGHT( D2, LEN(D2)-5)+1)and drag it down.