In this article we will show you how to extract First, Middle & Last Name from a given text string using multiple methods in Microsoft Excel.
Many a times you face a situation where in you are given a name list containing full names and you need to separate them on the basis of first, middle and last name and then return the result into different cells. This is a very common problem for any excel user, and you too must have come across it.
This is a very common distress for a lot of Excel users but there is no specific in-built function in Excel that can extract first name, middle initial and last name from a cell that contains a complete name.
But, there are multiple methods in Excel that can help you in doing the same. And, that’s what this article lesson is about.
Today, we will show you two different methods that can be used for splitting names into different cells.