Serial Numbers that begin with Text

  • Thread starter Thread starter KRC
  • Start date Start date
K

KRC

I need to assign several thousand numbers. However, the numbers must
begin with the text ISRC US-ABC-06- How can I use this prefix and
then automatically assign numbers.

For example:
ISRC US-ABC-06-00001
ISRC US-ABC-06-00002
ISRC US-ABC-06-00003
 
you obviously need to insert a formula to count which record you're o
(row above plus 1!)

then use =TEXT(serialnumber,"00000") - formats number a
text with 5 digits (adds preceding zeros)

then just join your text to this using &

eg. "ISRC US-ABC-06-" & TEXT (serialnumber,"00000"
 
Hand type the first two in their cells, say A1 and A2. Then highlight them
both and left click on the little black square in the lower right corner of
A2 and hold and drag it down the column.........the numbers will fill in
sequence.

hth
Vaya con Dios,
Chuck, CABGx3
 
If you want to autofill these numbers, just enter what you have used in your
example in A1:A3.

Select A1:A3 and drag/copy down column A.


Gord Dibben MS Excel MVP
 
Back
Top