Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-05-2009, 11:27 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Sort By Last Name in a List Sort By Last Name in a List 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort By Last Name in a List how do i take my contact list to a new computer? blade Outlook 2 01-13-2011 07:03 AM
Sort By Last Name in a List List option shashijb Excel 1 12-18-2008 03:07 AM
Which app to use for list on Outlook? sus Misc 0 08-26-2008 08:46 AM
creating a categories list owwiii Outlook 0 08-09-2007 01:56 PM
Creating a Map From a List of Addresses aleccamp Excel 0 11-19-2005 03:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft