Text to column (remove space and make three columns)

[SH_94]

Hi Community,

May i know how can i make the column as per screenshot below into three columns and appreciate if you can share with the workflow here.

Many thanks in advance.

[Qiu]

@SH_94 

Maybe with Make Column Tool?

[messi007 · Accepted solution]

@SH_94,

Please see below

Text to column will split one column into many based on the separator

If this solve your need please mark it as solved it will help others.

Attached the workflow,

Regards