View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JWG
 
Posts: n/a
Default How do I retrieve the text string from the right of a cell

I have a list of names that include first (sometimes middle) and last names.
I need to just pull out the last names. The length is not constant so I
cannot use the RIGHT function (as this only pulls the characters, not the
string). Sometimes there is a middle name or intial, so I can't just count
to the space (sometimes there are two spaces, or more).