I have several hundred rows of text which contains numbers. I need to separate the segments from each other. For example: "1twinkle twinkle little star 2how I wonder what you are 3up above the world 4so bright 5like a diamond 6in the sky 7shine so high 8twinkle twinkle 9little star 10how I wonder what you are"
The text between the numbers will vary in length and numbers may double digit but will always be in numerical order but not necessarily starting with 1.
I can do this with multiple steps: remove first number so as to be able to find the second number and then trim the left portion up to the 2nd number. Repeating this multiple times works. But there must be a simpler way. I get bogged down though when the numbers become double digit. Help please.