Hello, I am trying to find a quick way to add numbers (as text) to a sting of numbers should the same number be repeated multiple times in a sequence. The problem that I am running into is this:

Say I have cells that repeat the same number as shown below:

123456789
123456789
123456789
123456789

What I need is these numbers to read

12345678901
12345678902
12345678903
12345678904

... and so on

I am able to do this in an IF statement but the most I can get is for all the numbers in the sequence to end with "01" and I need them to ascend until the sequence ends.

Please help!!