Hello Mighty Excel Gurus,

I need some help cleaning up a list of strings

I've got a list of company names such as:

Mike's Big Shoe Co., LLC. Inc
Bobby's The-Real-Homemade Ice Cream Inc.
Brinc Theater
The Presidential Fan Club Corp.

I need to create a formula that will remove all instances of:

LLC
Inc
.
'
The - only if it precedes the company name
Corp,
Inc
etc

That way, all I'm really left with is the main part of the company name.
Doing a find and replace for each one of these separately is out to because it will remove things like the "inc" and "the" in "BrINC THEaters" and all i'd be left with is "Br aters"

Are there any Excel Jedi's out there who can solve this string clean up puzzle?

Thanks!