copy reference number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Assume text runs in A1 down
place in B1:
=TRIM(A1)&TEXT(COUNTIF($A$1:A1,A1),"000")
Copy down as far as required
 
Back
Top