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!
 

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
Need Text to Columns Help! First Name MI Last Name 5
Merge three fields into one 3
IF Function for MI in emails 4
Reversing Last Name and First Names 2
Remove middle initial from "first name middle initial" 15
copy down 9
Last initial 14

Back
Top