I am trying to extract the first and last names from a list but some of the names have 4 parts, I have a formula that does the job if the name only has 3 parts but not 4, examples as follows:
James Frank Van Helden needs to be James Van Helden
Tom John Bennet needs to be Tom Bennet
There is a mixture of 3 and 4 part names, is it possible to get a formula to handle the both in 1 formula or will it require separate formulas.
Thanks
Bookmarks