View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisapbs Lisapbs is offline
external usenet poster
 
Posts: 4
Default Sort by Last Name when name is combined

I inherited a worksheet where first and last name are combined in one cell
(i.e. Jane Doe) The first name is listed first. Can I sort this this by the
LAST name? How? If not, how can I split the text into two cells FIRST NAME
and LAST NAME?

Thanks! Lisa