Forum Discussion
Solved
Pulling out only last names from a listof people with two or three names
I am working with a list of full names. some of the people have only a first and last name, and some also have a middle name. I want create a list of only the last name. how do I do that?
Thank you
Is this the same question as in the other thread in which i've suggested a solution?
3 Replies
EXCEL 365 USERS ONLY
=CHOOSECOLS(TEXTSPLIT(A2, " "), -1)
For Older Excel Versions (2016–2021)=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",100)),100))
Is this the same question as in the other thread in which i've suggested a solution?
yes, it is.
