Thread: Sorting by surname when first name and surname are in the same cel
View Single Post
  #1  
Old May 12th, 2010, 05:05 PM posted to microsoft.public.excel.newusers
Louise
external usenet poster
  
Posts: 358
Default Sorting by surname when first name and surname are in the same cel
I have both first name and surname in one cell, ie. Mary Byrne and want to
sort my list of names by surname first. Is it possible to divide the cells
into two or is it possible to sort by surname when both names are in the
cell..