Friday, 11 May 2018

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

How to Separate First Middle Last Name in MS Excel (2003-2016), how to separate first middle & last name in excel, how to split names in different cell, change first middle & last time, combine name, merge name, divide names into first middle last, split names to different cell, name separate formula for excel, formula for name separate first middle last, excel 2007, excel 2016, excel tips & tricks, formula,  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

Popular Posts