Forum Discussion
Solved
Separate full name field into three separate columns.
I'm trying to separate the first,middle and last names into separate columns. The problem I'm running into is that some full names contain a "." with the middle initial and some do not and others sim...
Hello,
You can use the Flash Fill to extract (separate) and join (combine) first, middle and last name
Example:
Assume you have Full Name in column A1 such as Abiola David Smith where Abiola is the First Name, David is the Middle Name and Smith is the Last Name
In column B, type is Abiola and click Enter. Then execute CTRL + E. All the First Name in column A will be extracted. Then you can do the same for Middle Name and Last Name. So easy
On the other hand, you can use LEFT, MID/FIND and RIGHT functions to extract values.
Regards
You can use the Flash Fill to extract (separate) and join (combine) first, middle and last name
Example:
Assume you have Full Name in column A1 such as Abiola David Smith where Abiola is the First Name, David is the Middle Name and Smith is the Last Name
In column B, type is Abiola and click Enter. Then execute CTRL + E. All the First Name in column A will be extracted. Then you can do the same for Middle Name and Last Name. So easy
On the other hand, you can use LEFT, MID/FIND and RIGHT functions to extract values.
Regards
