Forum Discussion
Pulling out only last names from a list containing two and three word names
I have a question regarding TEXTSPLIT I'm dealing with a spreadsheet with a list of names in column A, some of which have only a first and last name, and some have a middle name as well. ...
=TAKE(TEXTSPLIT(A1," "),,-1)If you have access to the TAKE function you can use this formula.