First Name Extraction

[Floridagal]

I have a group of names like this:

Brown, Joe D.
Smith, Thomas
Black, Susan E
White, Lisa
Green, Chad T.

I can extract out the last name in a separate column, I am
having a problem extracting out the first name (in another
column) with out the middle initial. Any help would be
sooooo appreciated.

TIA!!!

 

[Chip Pearson]

Try the following formula:

=MID(A1,FIND(" ",A1)+1,IF(ISERROR(FIND(" ",A1,FIND("
",A1)+1)),LEN(A1),FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)))



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Floridagal]

Thank you Chip, works like a charm!!!!

-----Original Message-----
Try the following formula:

=MID(A1,FIND(" ",A1)+1,IF(ISERROR(FIND(" ",A1,FIND("
",A1)+1)),LEN(A1),FIND(" ",A1,FIND(" ",A1)+1)-FIND (" ",A1)))



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message news:[email protected]...


.

 

[Bob Phillips]

Hi Floridagal,

Try this

=MID(A1,FIND(", ",A1)+2,FIND("~",SUBSTITUTE(A1,"
","~",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-(FIND(",
",A1)+2)*(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=2))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)