Serial Numbers that begin with Text
 

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

Serial Numbers that begin with Text
 

you obviously need to insert a formula to count which record you're on
(row above plus 1!)

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

then just join your text to this using &

eg. "ISRC US-ABC-06-" & TEXT (serialnumber,"00000")


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556072

Serial Numbers that begin with Text
 

This should do what you're looking for.

="ISRC US-ABC-06-" & TEXT(ROW(),"00000")

KRC wrote:
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

Serial Numbers that begin with Text
 

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



"KRC" wrote:

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

Serial Numbers that begin with Text
 

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

On 27 Jun 2006 08:28:11 -0700, "KRC" wrote:

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