Single Column to Multiple Columns

Hello all,

I feel this may be trivial, but I can't get it with the different characters as I have a rudimentary understanding of macros... I have data that was copied into a single column and I need it into multiple columns based on spaces and certain characters. I would like to apply this to several thousand rows of data. Here is an example of what it current looks like:

>aaaaa1111|bbbbb22222|cccccc33333|ddddd44444;eeeee555555 fffff66666 gggggg77777 NAME

I'm trying to get it to be a column for every "|" ";" " "

Thus all of the entries shown above will be separated.

Thank you in advance for any and all help!

Best,

Ryan

You can do this for a regular text to columns - use Semicolon, Space and Other (In other type |).