Forum Discussion
Alif
Jul 17, 2025Copper Contributor
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 y...
- Jul 18, 2025
Is this the same question as in the other thread in which i've suggested a solution?
OlufemiO
Jul 21, 2025Brass Contributor
EXCEL 365 USERS ONLY
=CHOOSECOLS(TEXTSPLIT(A2, " "), -1)
For Older Excel Versions (2016–2021)
=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",100)),100))