How to separate cell value based on blank space

Question

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.

Sample file.xlsx

Luke_C · Accepted Answer

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.

Kurohits · Accepted Answer

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.