SOLVED SPLIT COLUMN INTO MULTIPLE COLUMNS

[Sivory18]

Hi I have a problem separating columns properly because the values are stuck into one column only.

i'll need it to look like this:

R00012 | AUD | 0 | 1 

R00013 | ALL | 41 | 76.41

but as you can see it's not all separated by the same amount of white space

[Warcry]

Use text to columns tool and change the delimited as a vertical bar |

[Warcry]

If this solves your problem, please accept as your solution.

[Sivory18]

Hi, the original data is not separated by " | " its just spaces. The reason i used " | " just represents a column. Refer to the screenshot

[Warcry]

Can you a txt file or csv, something better than squiggly lines.

[Warcry · Accepted solution]

Does this work?