Parse Names with Different Formats

[bridgethutter]

Hello,

I have a number of employee names I am trying to parse into a standard format. I know no matter what, I need to parse at the first comma. And I am just trying to get rid of the middle initial at the end but not all names have it and some first names have a double name with either a space or - in between. I want it to end up as last name and first name, however I have so many different formats, I am having a hard time finding the right regex formula. 

Current:

Employee Name
HUNTER,BRIDGETT T

HUNTER WONDERLIN,BRIDGETT T

HUNTER-WONDERLIN,BRIDGETT

HUNTER,BRIDGETT LOUIS T

HUNTER, BRIDGETT-LOUIS T

HUNTER, BRIDGETT-LOUIS

Desired Outcome

HUNTER                                        BRIDGETT

HUNTER WONDERLIN                 BRIDGETT

HUNTER-WONDERLIN                 BRIDGETT

HUNTER                                        BRIDGETT LOUIS

HUNTER                                        BRIDGETT-LOUIS

HUNTER                                        BRIDGETT-LOUIS

Thanks!

Bridget

[Emmanuel_G]

@bridgethutter 

In attachement an easy regex expression to do that.

[binuacs · Accepted solution]

@bridgethutter One way of doing this