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