I have a sheet with 3 columns of data. Fund Family, Fund Name, Share class. The Fund Name column includes the Fund Family and the Share class information. I would like to know how I can automate the deletion of that information from the Fund Name column.
Example

Existing =

Family Name Class
ABC ABC Growth A A
Alger Alger Small Cap Inst Inst


Would like to end with

Family Name Class
ABC Growth A
Alger Small Cap Inst

Thank you.

Corey