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.

Great question! Your post is quite informative, and organizing large datasets efficiently in Excel can make a huge difference.

To split long text into different columns, you can use the Text to Columns feature:
1️⃣ Select the column with the long text in Sheet 3
2️⃣ Go to Data > Text to Columns
3️⃣ Choose Delimited if your text is separated by commas, spaces, or other characters
4️⃣ Select the delimiter (e.g., space, comma) and click Finish
5️⃣ Copy the separated data into Sheet 1

Alternatively, if you need more control, Power Query can automate text splitting dynamically.

Hope this helps! Also, if you need a quick break, don’t miss out on the Exclusive Deals      at Arby’s menu—great offers that make any data-sorting session more enjoyable!

Parsing logic is not clear, perhaps you may clarify. For example, for Variant

if the part before first space includes dash (-) then Variant = "" and the part before first space goes to first column, etc.