autofill

  • Thread starter Thread starter yabaday
  • Start date Start date
Y

yabaday

Hello

I would like to create a custom list for autofill something like this
001-jn, 002-jn, 003-jn etc up to about 500-jn.

I'm going round in circles trying to produce it.

'preciate your help

yabaday
 
Put in the starting cell, say B2:
=TEXT(ROWS($A$1:A1),"000")&"-jn"
Copy B2 down


For filling across, change ROWS to COLUMNS,
i.e. use in the starting cell:
=TEXT(COLUMNS($A$1:A1),"000")&"-jn"
 
How about a formula:

=text(row(a1),"000")&"-jn"

Drag down and then edit|copy, edit|paste special|Values.
 
Back
Top