Formula to remove middle initials from name string

[Alex D]

My current naming convention is Doe, Jane L

I found this formula online, =IFERROR(LEFT(B2,FIND(" ",B2,FIND(" ",B2)+1)-1),B2) however, when I use it, it works perfectly for the Doe, Jane L example, but then turns the name of Doe Does, Jane to Doe Does,

Any idea how I can write a formula, to just remove that middle initial from a naming convention like Doe, Jane L ?

 

[pjmorris]

if the middle initial is always a single character then =Left(A1, Len(A1)-2) this assumes there's a space between the first name and the initial. If the initial isn't always present then this should test for a space in the second to last position and delete the initial if it therefore exists: =IF(MID(A1,LEN(A1)-2,1)=" ", LEFT(A1,LEN(A1)-2),A1). the latter formula is probably a better solution.