extract name

S

Shamu

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
 
M

Muhammed Rafeek M

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

challa prabhu

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top