We use a third party vendor to store and access our data. When running one key report it used to turn out a field of company names. We have a excel report that looks for their names in reports and counts them.

Some of the names are BRCM, Community Resource Center, or Hemingwey's Place. But some have hyphens in the name like BR-Corp or NJ-State, which is alright because we set up the report to count them.

Now the vendor has revamped their site and now that field produces both the company name and the contact name.
So now the fields comes out as BCRM - Margaret Jones or BR-CORP - Sam Johnson.

I can run a formula to get rid of the hyphen and everything after the hyphen but that would eliminate everything after the hyphen in name that naturally have the hyphen.

So I would get BCRM AND BC, when I need BCRM and BR-CORP

Other than yelling at my vendor, is there a formula to remove the hyphen and everything after only after a certain point and preserve entries where the hyphen should be there?

Thanks