Excel Shortcuts - Split Forename and Surname

• Finding the Middle name

Full Name	Middle Name
Alan David Jones	David
Bob John Smith	John
Carol Susan Williams	Susan
	=LEFT(RIGHT(C45,LEN(C45)-FIND(" ",C45,1)),FIND(" ",RIGHT(C45,LEN(C45)-FIND(" ",C45,1)),1))