Pulling only first name

  • Thread starter Thread starter krc547
  • Start date Start date
K

krc547

I need to pull the first names and first initial of last name into a cell. In
cell g I have the first and last name (john doe). I need cell c to look at
cell g nad return only john d.
 
I need to pull the first names and first initial of last name into a cell. In
cell g I have the first and last name (john doe). I need cell c to look at
cell g nad return only john d.
Click to expand...

Assuming the format is like what you show, then:

=LEFT(TRIM(G1),FIND(" ",TRIM(G1)))&MID(TRIM(G1),FIND(" ",TRIM(G1))+1,1)

--ron
 
If some of the names have middle initials (ie, John Q. Doe), this formula
will work (works without the middle initial also):

=LEFT(G1,SEARCH(" ",G1))&IF(ISERROR(SEARCH(".",G1)), MID(G1,SEARCH("
",G1)+1,1), MID(G1,SEARCH(".",G1)+2,1))

Hope this helps,

Hutch
 
Back
Top