Hello and thanks for reading my post.

I am a column (I) of names that have peoples names in them. Some have just their first and last name, some middle initial, and some their full middle name. Is there a formula that would take out the middle name/initial if they had one. Here are some examples

John Anderson (no middle name - want to keep this as is)
John B Anderson (Middle Initial - want to get rid of the B)
John Bernard Anderson (Middle Name - Want to get rid of Bernard)

The format for the names are exactly like the examples. First name - Middle name/initial if they have on - Last Name

Thanks for your help