B
Brenda
How can I parse out a Name, ex: John J Jones, into First,
Middle Initial, Last Name.
Thanks in Advance!
Middle Initial, Last Name.
Thanks in Advance!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy B
Brenda
Try using Data/Text to Columns. Following the wizard is straightforward.
Andy.
Try using Data/Text to Columns. Following the wizard is straightforward.
Andy.
B
Bob Phillips
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.
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.
A
Andy Brown
If you need to deal with some names w/out middle inits, check out Chip's
formulas at
http://www.cpearson.com/excel/FirstLast.htm
Rgds,
Andy
formulas at
http://www.cpearson.com/excel/FirstLast.htm
Rgds,
Andy
B
Bob Phillips
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))))
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))))
B
Brenda
Thanks for all your great feedback!!