First name, Middle Initial
 

I have a column that has first Name, Middle Initial. Like this...

Lauren M
Elise C
David K
LeSean

As you can see, LeSean does NOT have a middle initial. I tried this formula
to try and simply just get the first name WITHOUT the middle initial, but it
didn't seem to work.

=LEFT(B2,FIND(" ",B2)-1)

Can someone PLEASE help me out here...

Thanks in advance!

Try...

=IF(ISNUMBER(SEARCH(" ",A1)),LEFT(A1,SEARCH(" ",A1)-1),A1)

Hope this helps!

In article ,
"wnfisba" wrote:

I have a column that has first Name, Middle Initial. Like this...

Lauren M
Elise C
David K
LeSean

As you can see, LeSean does NOT have a middle initial. I tried this formula
to try and simply just get the first name WITHOUT the middle initial, but it
didn't seem to work.

=LEFT(B2,FIND(" ",B2)-1)

Can someone PLEASE help me out here...

Thanks in advance!

Hi

Try
=IF(ISERROR(FIND(" ",B2)),B2,LEFT(B2,FIND(" ",B2)-1))

Regards

Roger Govier


wnfisba wrote:
I have a column that has first Name, Middle Initial. Like this...

Lauren M
Elise C
David K
LeSean

As you can see, LeSean does NOT have a middle initial. I tried this formula
to try and simply just get the first name WITHOUT the middle initial, but it
didn't seem to work.

=LEFT(B2,FIND(" ",B2)-1)

Can someone PLEASE help me out here...

Thanks in advance!