First name, Middle Initial

[wnfisba]

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!

[Domenic]

Try...

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

Hope this helps!

In article <C01B48CB-32D1-468C-A7D1-044A6FB48FC2@microsoft.com>,
"wnfisba" <wnfisba@discussions.microsoft.com> 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!

[Roger Govier]

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