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

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

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

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