How to Separate First Middle Last Name in MS Excel (2003-2016)

Microsoft Excel came with many useful formulas one of them is separates name, in this article I will shows you how to separate full name into first name, middle name & last name in different cell.  This formula will work all the version of Excel like 2003 to 2016. Just use the formula given below… Watch video for better understand.. 

Formula :

First Name : =LEFT(B3,FIND(" ",B3)-1)

Middle Name : =MID(B3,FIND(" ",B3)+1,FIND(" ",B3,FIND(" ",B3)+1)-FIND(" ",B3)-1)

Last Name: =RIGHT(B3,LEN(B3)-FIND(" ",B3,FIND(" ",B3)+1))

Note: (Replace the Cell Number with yours)

Watch video tutorial… Please like, share & subscribe