Splitting Long Text into Different Columns in Excel

From what I gather from your workbook, Sheet1 contains the hint at how the columns should be split.

For illustrative purposes, I've changed the font color for the first entry to indicate how the words are to be separated from what I understand:

It's tempting to use regex capture groups but it's probably needlessly complex for this task when flash fill can produce the results in the capture above. To use flash fill with this data you have to provide an example of how the text is to be split like this:

Select the cell below "PRO" and press ctrl+E to activate flash fill.  Repeat for the other columns going left-to-right. Be sure to select one cell at a time.