Forum Discussion
How can I change list Alphabetically from last name to first?
Hello,
I have a list of contacts that I would like to share with an elderly gentleman that knows most of them by first name but my list is by last name. Is there a way to do this without re-writing it?
Thank you all you excel-lent! experts! Sorry, couldn't help myself...
2 Replies
- I'm guessing the list is formatted something like Lastname, Firstname?
you can break that column into 2 columns using the 'Text to Columns' button under the Data tab in the Data Tools grouping. then when it is broken into 2 column you can sort by the first name column
using a formula like this could also work:
=TEXTSPLIT(A1,",",,,,"")
where A1 is the first name and then copy down the length of the list.
on an older excel you can get the first name using
=MID(A1,IFERROR(SEARCH(",",A1)+1,1),999)
and last name using
=LEFT(A4,IFERROR(SEARCH(",",A4)-1,999))
