How to Break Full Name...............?

How to extract Title from Full Name ?

=LEFT(“Title Firstname Middlename Lastname”,find(“ “,“Title Firstname Middlename Lastname”)-1)

How to extract First Name from Full Name?

Find first space position(FSP)

FSP= FIND(“ “,“Title Firstname Middlename Lastname”)

Find second space position(SSP)

SSP= FIND(“ “,“Title Firstname Middlename Lastname”,FSP+1)

Find first name length(FNL)

FNL=SSP-FSP-1

Extract First Name

=MID(“Title Firstname Middlename Lastname”,FSP+1,FNL)

                OR

=MID(“Title Firstname Middlename Lastname”, FIND(“ “,“Title Firstname Middlename Lastname”)+1, FIND(“ “,“Title Firstname Middlename Lastname”, FIND(“ “,“Title Firstname Middlename Lastname”)+1)- FIND(“ “,“Title Firstname Middlename Lastname”)-1)