Separating Grouped Numbers into Individual Numbers

[tomtingley]

Hi,

I'm trying to change the numbers from this:

1014161929LUCKYSTARS0210

To this:

10 14 16 19 29 02 10

I've used the Lottery numbers as an example in the attached.

Hope this makes sense!

[DataNath · Accepted solution]

Hey @tomtingley, here's one way I'd go about this. The inner function just replaces any non-number (\D) with nothing. The outer function then replaces each 2 characters (that aren't at the end of the string) with those 2 characters + a space:

[tomtingley]

@DataNath Thanks so much!

Is there any possible way to segregate the numbers into seperate cells.

So rather than 10 14 16 19 29 02 10 in one cell, I'd want 10 in one cell, then 14 in the next etc?

[gautiergodard]

Hey @tomtingley You could add a text to columns tool after the solution provided by @DataNath and use the \s delimiter to separate the string into different columns.