G

#### greenemm

I'm a newbie with very little excel experience. I have a problem which

would very much apprieciate the assistance of you experts with

I have a series of numbers in a list. Each of the numbers in the lis

can be up to 12 digits long (but can also be shorter):

54114059

54114059

54114059

54114059

54114059

54114059

54114059

54114059

54114059

5411406

5411406

5411406

5411406

5411406

5411406

5411406

5411406

5411406

5411407

5411407

5411407

5411407

5411407

5411407

5411407

5411407

5411407

5411407

5411408

5411408

5411408

5411408

5411408

5411408

5411408

5411408

5411408

5411408

In this example (from the list above) the first set of numbers are nin

digit long starting 541140590. If I truncate these to the 8th digit the

would all be the same, right? So it would be fair to say that 'if' th

nineth digit of the first block covered the complete range of 0-9

truncating would not be a problem. However, as you can see the numbe

541140591 is missing from the range, so I do not want the rang

truncated

The next block of numbers are eight digits long starting from 54114060

Like the first set, by the considering the last digit (ie the eight

digit in this case) on each of the numbers doesn't cover the full rang

of 0-9 as 54114063 is missing. These should also not be truncated

However, the next (third) set are also eight digits long starting fro

54114070. Unlike the first and second set of numbers the last digit (i

the eigth digit) on each of the numbers covers the full range of 0-

(with none missing). This means that these can and should be truncate

to seven digits (namely 5411407). And so on for the next groups o

numbers startomg 54114080. Which can (following the above rules) b

truncated to 5411408

The question is, how do I get MS Excel to do this for me, either b

usings a macro, or a formula which I can paste into an adjacent cell

that will show any truncated numbers together with those that (followin

the rules above) should not truncated (so that I can drag it down)?

Thanks in advance of your anticipated assistance

Kind regard