Find any stand alone letter and replace with ""

[Stuepef]

I have a spreadsheet where users can paste employee census information with varying formats. Is there a formula that would locate any stand alone letter (A-Z) within a cell and replace it with ""? Here is how the names can be formatted:

Washington,Richard Y (Last,First)

White, Julie K (Last, First MI)

Brown,Tony F (Last,First MI)

Joan T Franks (First MI Last)

Bobby U Flarry (First Last)

<tbody>
</tbody>

Desired Result:

Washington,Richard

White, Julie

Brown,Tony

Joan Franks

Bobby Flarry

<tbody>
</tbody>

Thank you!

 

[Eric W]

Possibly:

=REPLACE(A1,AGGREGATE(15,6,SEARCH(" "&CHAR(ROW(INDIRECT("65:90")))&" ",A1&" A "),1),2,"")

but these kind of formulas always have issues when the data is formatted inconsistently, with extra spaces, commas, periods, etc.