Best way to isolate just company names from this messy column

[novawaly]

Hi, 

I have a column of names that is in very sloppy format. It generally follows a Company name - Stat - City so I was thinking text to columns and split on the first "-" however, some company names will have a "-" in their actual name (is A1-trucking - Las Vegas - NV. What's even worse is some dont have any dashes at all and might only include a company name with no location. 

Also, I'll eventually have to do a fuzzy match to match duplicates - is it better to do that before or after I attempt to split out the company names?

Thank you so much!

[binuacs]

@novawaly @Can you provide the data in an excel sheet?

[novawaly]

added to the original message - sorry should've done that in the first place. 

[binuacs · Accepted solution]

@novawaly this can be done using RegEx tool

[novawaly]

Wow that's amazing. I'm horrible with regex. Just for my own edification, do you happen to know where I can figure out/follow what that's doing?