extract name

[Guest]

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

 

[Guest]

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))

 

[Guest]

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

 

[Ron Rosenfeld]

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