Simple macro to insert a new row if 2 numbers exceeding 99999999 are next to each other

[ostego]

Hi,

The data i currently have is structured in a way like this all in one column (A)

[12-20 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[12-20 digit number]
[12-20 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[12-20 digit number]
[12-20 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[12-20 digit number]


And so on, i just need a macro that will insert a blank row inbetween the 12-20 digit numbers (figure the easiest way to define these numbers to excel would just be to do it for values that exceed the max. number the 8 digit numbers could be, i.e. 99999999), to separate them

so it would look like this :

[12-20 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[12-20 digit number]

[12-20 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[12-20 digit number]

[12-20 digit number]
[8 digit number]
[8 digit number]
[8 digit number]
[12-20 digit number]

Could anyone help me out on this one? Have spent an hour trying to it, and I know you guys will find it so simple!!

I have attached an excel sheet with example data data.xls

Thanks for your help

[Kaper]

try this:

Please Login or Register  to view this content.