Text to Columns - Splitting Numbers without Delimiters

[bdoni001]

Hello everyone!

Here is the detail of what I want to achieve.

I want to make something like in the picture below:

Is it possible to achieve the above by using the text to columns tool only? Or are there any additional steps that I have to do?

Really appreciate the assistance here.

Thank you!

[flying008]

Hi, @bdoni001 

FYI.

[bdoni001]

Hello!

Thank you for the response!

This is definitely what I need. However, can you share the Regex configuration?

[flying008 · Accepted solution]

Hi, @bdoni001 

If your text contain number and string char, maybe you can use expression '(.)' 

******

If can help you get your want, please mark it as a solution and give a like for more share.

[bdoni001]

Once again, thank you very much!