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.
| John Smith | |
| Eric Trevor Madison |
I need to pull out only the last names from each entry in column A and enter it into column B. How can I do this.
Thank you
1 Reply
=TAKE(TEXTSPLIT(A1," "),,-1)If you have access to the TAKE function you can use this formula.
