autofill limits

[Candy]

Excel autofill does not work with large numbers with text in front. I can
get it to work with the number smaller than MT800225000 but if it is larger -
MT800225000300, it will not sequence the numbers. Are there limitations to
the amount of text characters that will work? If so what are the alternatives?

 

[Hans Terkelsen]

Excel autofill does not work with large numbers with text in front. I can
get it to work with the number smaller than MT800225000 but if it is larger -
MT800225000300, it will not sequence the numbers. Are there limitations to
the amount of text characters that will work? If so what are the alternatives?

Hi Candy.

Details are often interesting, thanks for showing this one.
One could guess that the limit was 2^32, 4294967296
and sure enough, the next fill after
SomeText4294967295 is
SomeText0

No elegant way around it, that I can find,
I would fill down X000300
and FIND/REPLACE X with MT800225

Hans T.

 

[Tom Hutchins]

You could separate the text from the numerical part of the entry, then
autofill the numerical part. That should allow you to autofill as high as you
want (until you run out of rows or exceed Excel's 15 digits of precision).
Then copy the text portion down and concatenate the text back with the
numbers.

Hope this helps,

Hutch