Thread: extract name
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default extract name

On Sun, 12 Aug 2007 21:24:08 -0700, Shamu
wrote:

How can i extract full name to Last Name, First Name, Middle Name

Full Name format: Canas Fernando De Paz

Extracted Format:
LN: Canas
FN: Fernando
MN: De Paz



Can you develop a list of unambiguous phrases that, when present, consitute the
beginning of Last Name?

For example:

Paz
De Paz
De La Hoya

If you can, then the extraction might be doable with Regular Expressions.
--ron