Parse out a name

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

How can I parse out a Name, ex: John J Jones, into First,
Middle Initial, Last Name.

Thanks in Advance!
 
Brenda,

If it's spaces between, just go to Data>Text To Columns and use space as the
delimiter. It will automatically move to separate columns then.
 
Following Bernard's response, here are 3 formula to get them assuming name
in A1
in B1, =LEFT(A1,FIND(" ",A1)-1)
in C1, =IF(ISERROR(FIND(" ",RIGHT(A1,LEN(A1)-FIND(" ",A1)))),"",FIND("
",RIGHT(A1,LEN(A1)-FIND(" ",A1))))
in D1, =RIGHT(A1,LEN(A1)-(IF(ISERROR(FIND(" ",A1,FIND(" ",A1)+1)),FIND("
",A1),FIND(" ",A1,FIND(" ",A1)+1))))
 

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

Similar Threads

Formula To Split Name 5
Excel - Parse Name 6
Lookup Help Please?! 2
Matching Names 5
Parsing text in a cell 1
Parse Name field with multiple characthers 1
Excel Concatenate Form Name to Parse for function 1
Name Format Formula 4

Back
Top