Microsoft Excel's Text to Columns is a powerful feature that can split texts into multiple columns. You find it under Data > Data Tools > Text to Columns . With the keyboard shortcut ALT + A + E you can also access this feature.

In the following example, I will separate the list into first name, middle name and last name. It's a three step procedure.

First, select your data set (A2:A9).

Under Data tab > from the Data Tools group click Text to Columns. This will open the Convert Text to Columns Wizard. Look, every wizard has a Data preview window to see how your data is taking new shape