Alternatively, this video:

https://youtu.be/fRjsK-NXVEA

(Key word: "Maruary".)

Cool find! The 100-second video segment starting at 10:43 in this link that I am sharing would be more fun: <https://www.youtube.com/watch?v=421gU482xFE&t=643s>

Here's an illustrative demo of the Flash Fill capability. Check out the 3 minute video segment starting at 4:30. <https://www.youtube.com/watch?v=X1YXge3C8RI&t=270s>

Seems like a lot more work than doing Data > Text to Columns :)

As someone who has been handling delimited text for decades, Text to Columns is the most natural approach. That being said, different people have different backgrounds and approach problems from different angles. Flash Fill may be more appropriate in their cases.

Yes, text to Columns would work well for splitting tasks in a very uniform dataset. However, if you want to extract say Lastname from a column containing names some of which may have middle names (i.e., the dataset is not very uniform), then text to columns would not work correctly.

Also, if you would like to do more than substring extraction, say convert "FirstName LastName" into "f.l." or "lastname, firstname", then Text2Columns won't be sufficient by itself. You would need to do more post-processing or would need a more sophisticated scripting capability.