Delete everything after the last special character

Hello, I am working with a spreadsheet that contains names of clients in one column, but their names have been merged with various service types and locations.

The basic pattern is that anything right of the last " -" can be deleted (that's a space and a hyphen). The trick is that there may be additional spaces and hyphens, but they can stay. Also, not every cell contains a hyphen at all. Some are fine as-is.

Any takers on helping me puzzle this one out? I mirrored something similar from online and got close, but not 100%.

Thanks for taking the time,

How about

Formula:

Please Login or Register  to view this content.

Wow, Fluff's solution did the trick. I just added a space before the hyphen, within the quotes.

Alan, I like that idea of learning PQ. Just gotta get management to agree that it's the right tool for us.

Thank you,

Glad to help & thanks for the feedback.