Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I extract each Max key value ? | New Users to Excel | |||
Trying to extract every third line | Excel Discussion (Misc queries) | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Last Name, First Name extract | Excel Discussion (Misc queries) | |||
how to extract a filename? | Excel Worksheet Functions |