Extract the frist name & last name in Excel
Example:- Rajeev Ranjan Kumar:- O/p first name;- = IFERROR(LEFT(A21,(FIND(” “,A21))-1),A21) mid name;- = MID(A21,FIND(” “,A21)+1,FIND(” “,A21,1+FIND(” “,A21))-FIND(” “,A21)-1) last name:- = RIGHT(A21,LEN(A21)-FIND(” “,A21,FIND(” “,A21)+1)) here “A21″ is a cell value ref.