How do I split string text and numbers into different columns?

[newalteryxuser435]

Hello everyone, 

I am having a bit of trouble figuring out how to split text and numbers that are in the same column into a different column. 

An example:

New User 1.0 9.0 10.0 6.0 5.0

I want the split to look like

New User | 1.0 | 9.0 | 10.0 | 6.0 | 5.0

I have tried many ways but I think Text to Column is the one that will work but the delimiter I use (a space) gives me something like: New | User | 1.0 etc

Please let me know what I can do! Thanks

[flying008]

@newalteryxuser435 , Dear, hello!

1- you need regex to process space between letter first. (the expression like ([^\d])\s([^\d]) )

2- text to columns for split the string.

3- delete all null columns.

4- replace space to restore string.

[newalteryxuser435]

@flying008 That regex statement is not giving me the correct output, another example: Data Model 2.0 1.0 5.0. It does not work 

[flying008 · Accepted solution]

@newalteryxuser435 , 

Dear, this looks fine on my way, please try again.

[Sebastiaandb]

@flying008 what program do you use to make those .gifs? awesome!

[flying008]

@Sebastiaandb , oCam for you !

[newalteryxuser435]

It worked now haha! Thank you so much