View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb
 
Posts: n/a
Default Extract last name and insert into a different field.

I want to extract a person's last name from a field & put it into another for
sorting purposes. If their name is Bud Line, I want to put Line into a
different field. If their name is Betsy Sue Color, I want to put Color into
a different field. I think their should be a way to search for the space
starting from the right side, but I don't know how. The problem I'm having
is if their name is listed as first, middle and last.