I have a column which contains a list of names, I want two other columns to contain functions which extract the first and last name. So far I have this
FirstName: =LEFT(D3,FIND(" ",D3)) LastName: =RIGHT(D3,LEN(D3)-FIND(" ",D3))
This works for names in the format "First Last", but it doesn't work when there is extra information such as "Mr. First Last".
Is there a better way to go about this?