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:

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Washington,Richard Y (Last,First)[/TD]
[/TR]
[TR]
[TD]White, Julie K (Last, First MI)[/TD]
[/TR]
[TR]
[TD]Brown,Tony F (Last,First MI)[/TD]
[/TR]
[TR]
[TD]Joan T Franks (First MI Last)[/TD]
[/TR]
[TR]
[TD]Bobby U Flarry (First Last)[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Desired Result:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Washington,Richard[/TD]
[/TR]
[TR]
[TD]White, Julie[/TD]
[/TR]
[TR]
[TD]Brown,Tony[/TD]
[/TR]
[TR]
[TD]Joan Franks[/TD]
[/TR]
[TR]
[TD]Bobby Flarry[/TD]
[/TR]
</tbody>[/TABLE]

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.