Thread: [Solved] Sort By Last Name in a List
View Single Post
 
Old 05-05-2009, 11:27 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Lightbulb 1 Solution

If you highlight the list and turn it into a table:
(2003)
  • Table > Convert > Text to Table
  • (for a separator, use a SPACE)
(2007)
  • Insert > Table > Convert Text to Table
  • (for a separator, use a SPACE)
You can then sort the table by column 2:
(2003)
  • Highlight table
  • Table > Sort
  • Sort by > Column 2
(2007)
  • Table Tools > Layout
  • Sort
  • Sort by > Column 2
Then, if needed, convert back to text.
Reply With Quote