How to separate cell value based on blank space

[Gsiva3]

Hi Team,

I have a input with field as AAABBB CCCDDD EEE FFF. I want to split this data into column based on the "Blank Space" between the values. 

I have attached sample input and output.

[Luke_C · Accepted solution]

Hi @Gsiva3 

The text to columns tool can help with this. See below, I used the split to rows option to get your desired results. The \s delimiter represents a space. 

[Gsiva3]

@Luke_C 

Thanks Luke😊

Its working fine👍

[Kurohits · Accepted solution]

Hi, 

It can be done using regex tool. Use (\w+) regex to split data after spaces. check the configuration tool on regex tool. 

Attached solution. Please accept as solution if this is working fine for you.