I need a formula that will add 1 for each record of a reference number.
exaplme: my first reference number is jn51000001. I need a formula to copy
and paste down a good 20,000 cells. I can't use =sum(a1+1) because of the
text in it.
I desparately need help on a formula that will work.