View Single Post
  #1   Report Post  
excelnewbie
 
Posts: n/a
Default Reversing First and Last Names

I am extracting one single column from word where the person's name is
written "Mr. John Smith." Is there any way in excel to have it appear as
"Smith, Mr. John" It can be in the same column but I need to be able to sort
by the last name - not the title!