Looking for a Formula to get rid of middle initial

[Stephen_IV]

I have the data below all are formated the same, what I would like to do is to have a formula take out the initial. I know that I could use Text to Columns but would rather have a formula to accomplish this. Thanks in advance Stephen!

Lusi
Cesar
Elena
Evelyn
John D
Cathleen M
Ann M
Thomas
Victor M
Cristina M
Mayra L
Rebecca I


to

Lusi
Cesar
Elena
Evelyn
John
Cathleen
Ann
Thomas
Victor
Cristina
Mayra
Rebecca

 

[Jonmo1]

You could use

=LEFT(A1,FIND(" ",A1&" ")-1)

Hope that helps.

 

[Stephen_IV]

jonmo1 That did it! Thank you so much I just could not get it! Thanks again!