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!