View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Louise Louise is offline
external usenet poster
 
Posts: 217
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..