Eliminați spații din unele coloane înainte de virgulă

The site for which my data was pulled has upgraded and now names of individuals who purchase new plans have a space in between their name (last , first), while older individuals with plans are your typical (last, name).  The only problem is that if a previous version person purchases a new plan, then old plan will show the old way and then new plans show the new way, and when subtotaling they are recognized as two different people.  How do I create a column to clean this space out so they can all be the same so subtotal can recognize them?
PolicyholderPolicy NumberLine of Business Post-Tax Amount  Pre-tax Amount Coverage TypeStatusLast , First12345678STD $       31.20 $               -  INDNewLast , First Total   $       31.20 $               -    Last, First13254646CANCER $              -   $        16.75IND Last, First65688315ACC $              -   $        12.22IND Last, First Total   $              -   $        28.97