Dealing with middle names

If your data consistently has middle initials or names (meaning every name has one), Flash Fill works the same way, but you follow the steps three times instead of two.

More about Flash Fill

Your data doesn't have to be names, of course. Flash Fill works with any data you need to split into more than one column, or you can simply use it to fill out data based on an example. Flash Fill typically starts working when it recognizes a pattern in your data.

However, Flash Fill may not always start filling out your data. It works best when your data has some consistency. For example, all names have middle initials or all addresses use the same type of postal codes. If your data has many inconsistencies, you can always use Text to Columns to split text into different cells, or use functions to split text.