Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alphabetizing in Excel
I know about the sort function in Excel. I have a column of names, first
name followed by the last name. Can I get Excel to sort them by the LAST name? Thank you. |
#2
|
|||
|
|||
You need to create an additional column that contains only the
last name, and sort on that column. For simple first and last names, the following formula will return the last name of the full name in A1. =MID(A1,FIND(" ",A1,1)+1,99) Copy this formula down as far as you need to go. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "FORMULA QUESTION" wrote in message ... I know about the sort function in Excel. I have a column of names, first name followed by the last name. Can I get Excel to sort them by the LAST name? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Alphabetizing a list in Excel | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |