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!
|