Evening,

I have a list of names in the following format: Last, First Middle. What I need is a formula that will remove the middle name, and re-arrange the format to First Last with no comma separating the names. Currently the entire name is contained in a single cell and I would like it to remain that way.

I have:
Gates, Bill Henry

I want:
Bill Gates

Thank you for your assistance.