LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Reb
 
Posts: n/a
Default Sorting a list of names by last name.

Using Win XP, Excel 2003. All updates installed.

Unfortunately the full name is contained in one cell. for example, Cell A1
contains: John P. Jones. The worksheet cannot be changed so setting up
separate columns is not an option. Is there any way to sort the column by
last name?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
i want to only select one name from a list of the same names rhinozw Excel Discussion (Misc queries) 5 May 21st 08 07:20 PM
looking up names in a list macca Excel Worksheet Functions 1 November 15th 05 02:29 AM
filter 400 names from list 1 from list 2 with 4000 names Ed Excel Worksheet Functions 2 September 4th 05 03:41 PM
How do I print a list of worksheet tab names in a workbook Clif Excel Worksheet Functions 3 March 2nd 05 09:38 PM
Sorting for specific words/numbers in a list Heyna Excel Worksheet Functions 1 November 15th 04 07:59 PM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"