First name, Middle Initial

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
Try...

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

Hope this helps!
 
Hi

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

Regards

Roger Govier
 
You must log in or register to reply here.

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
Formula To Split Name 5
Need Text to Columns Help! First Name MI Last Name 5
Merge three fields into one 3
Excel: Sort alphabetically using the last word in a cell? 1
Concatenate first, middle and last names 1
Separate First, Last Names 2
Left, Right & If Function 2

Back
Top