How to Find and Replace Function Using Wildcard or Formula

Hi Excel Forum Team,

I have a long column set of cells each containing a the vendors name that I only require and also contains text content such as spaces, colon, and the companies location that I don't wish to have.

So, my question is who do I perform a Find and Replace function (or possibly formula) to remove all cell text content (spaces, colon, and the companies location) just after and to the right of the last letter of the vendor name?

For Example...

Original Vendor Name List Export
3M CO :INDIANAPOLIS
AMT METAL FABRICATORS INC :RICHMOND
ART LLC ADVANCED REFINING TECHNOLOGIES LLC :COLUMBIA
ABB INC :WESTERVILLE

Then after the Find and Replace function (or possibly formula) each cell text will look like this.

Modified Vendor Name List
3M CO
AMT METAL FABRICATORS INC
ART LLC ADVANCED REFINING TECHNOLOGIES LLC
ABB INC

Thank you for your help and review of the problem I'm having trouble solving.

Garrett