Delete numbers in cell

can you describe the rules in simple words that identify what constitutes the company name? Is it UNITYMEDIA or UNITYMEDIA H or UNITYMEDIA GMBH? Is it AGROKOR D or just AGROKOR? If you can come up with a logical explanation, then someone here will be able to come up with a function or macro.

But if the recognition of the company name involves human interaction, then you're pretty much out of luck.