Extracting the Middle Initial/Middle Name

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

Thanks kbkumar, I was going to use that as my final hoorah if there wasn't a formula that would remove the middle names if there was one.

You were right on the money. Thanks Marcol, that worked awesom. I do have a quick question if you don't mind, what does the "|" represents or used here for?

Go with Star of the Month (July) I wasn't thinking clearly! ...