MellowMe wrote:
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.

This is my first piece of data: test0000001 (it is located in cell
AF3)

This is formula to do what you want, to the first piece of data:

=CONCATENATE(MID(AF3,1,4),TEXT((MID(AF3,5,7)+1),"0 000000"))

Copy it down the column after you adjust for positions of your data in
initial string of jn51000001.

Use the excel help to figure out how MID and TEXT and CONCATENATE
functions work.