Split Forename and Surname in Excel
Finding the First Name
=LEFT(B5,FIND(" ",B5,1))
Finding the Last Name
=RIGHT(B13,LEN(B13)-FIND(" ",B13))
Finding the Last name when a Middle name is present
=RIGHT(B26,LEN(B26)-FIND("#",SUBSTITUTE(B26," ","#",LEN(B26)-LEN(SUBSTITUTE(B26," ","")))))
Finding the Middle name
=RIGHT(B26,LEN(B26)-FIND("#",SUBSTITUTE(B26," ","#",LEN(B26)-LEN(SUBSTITUTE(B26," ","")))))