Thread: Alphabetizing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gregory Coin Gregory Coin is offline
external usenet poster
 
Posts: 1
Default Alphabetizing

I received a file with the full names of individuals in each cell in a column
-- i.e. "Fred A. Jones" all in one cell. I would like to sort the names
alphabetically by the last name (last word in each cell). Is that possible
and if so, how do I do it without going into each cell manually? Thanks.