copy reference number

[Guest]

I have created a large spreadsheet

Some 30000 Items

I wsh to add a field for MYREference number at the end of each line

for example badtimes1 then I would like to be able to automatically copy
badtimes1 all the way down to badtimes3000o with a copy/Formula I am not ure
how how to do this


Any help would be most appreciated

 

[Guest]

Assume text runs in A1 down
place in B1:
=TRIM(A1)&TEXT(COUNTIF($A$1:A1,A1),"000")
Copy down as far as required

 

[Guest]

=A1&ROW(A1)