extract name
 

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

extract name
 

B1: =LEFT(A1,FIND(" ",A1))
C1: =MID(A1,LEN(B1)+1,FIND(" ",A1,LEN(B1)+2)-LEN(B1))
D1: =RIGHT(A1,LEN(A1)-LEN(B1&C1))


"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

extract name
 

Hi,

Add another header column and enter this function in the row cell

Joins several text strings into one text string.

Syntax

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single text
item. The text items can be text strings, numbers, or single-cell references.

Remarks

You can also use the ampersand (&) calculation operator instead of the
CONCATENATE function to join text items. For example, =A1&B1 returns the same
value as =CONCATENATE(A1,B1).

Challa Prabhu

"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

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