One way would be to go ahead and put 51000001 in A1 and 51000002 in A2 and
select both and drag down to A20000, then in B1 put ="jn"&A1 and copy down
and then Copy PasteSpecial Values on column B to eliminate the
formulas..........

Vaya con Dios,
Chuck, CABGx3



"MellowMe" wrote in message
...
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.