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.