Excel Formula for First, Middle and Last Name

Hi,

I want to write a formula in Excel to get First Name, Middle Name and Last Name.

Please help me to achieve the desired output.

Name First Name - Output Middle Name - Output Last Name - Output
Shahzad Hussain  Shahzad   Hussain
Abhishek kumar  Abhishek   Kumar
mayank Gupta  mayank   Gupta
Shreya  Shreya    
Nishi Verma  Nishi   Verma
Anu  Anu    
SAURAB SINGH SAURABSINGH   Singh
Ankit Kumar Singh  Ankit Kumar Singh
Shubham Kumar Gupta  Shubham Kumar Gupta
rohan gupta rohan   Gupta
Harshit Tanwar  Harshit   Tanwar
soniya verma soniya   Verma
NITIN KUMAR  NITIN   Kumar
Manoj Maurya  Manoj   Maurya
geeta negi  geeta   Negi
Dharmender Singh  Dharmender   Singh


Thanks,

  Devbrat Tripathi

Hi sir,


Here is the answer to your question

First Name = LEFT(A3,FIND(" ",A3))

Middle Name = IFERROR(LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3)),FIND(" ",RIGHT(A3,LEN(A3)-FIND(" ",A3)))),"")

Last Name =IFERROR(RIGHT(A3,LEN(A3)-FIND(" ",A3,FIND(" ",A3)+1)),RIGHT(A3,LEN(A3)-FIND(" ",A3)))

  Mukul Rajput       10 Feb 2018       1       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any