First name, Middle Initial

G

Guest

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

Roger Govier

Hi

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

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Middle Initial From First Name 9
Merge three fields into one 3
IF Function for MI in emails 4
Last initial 14
Reversing Last Name and First Names 2
Remove middle initial from "first name middle initial" 15
Separate first name, middle name and last name 2
Need Formula for Extraction of Middle Initial or Name 6

Top