Name cleansing and Parsing

[spencer046]

I have the below dataset:

AMD CO DIST CENTER

Bi Tech Industries

CZ INDUSTRIES

D I S COMPANY LTD

A AND B HOMES CO

Hi Tech CO DIST Center

I want to get rid of the 2/3/4 letter words from the names, either from the end or in the middle, leaving the first part of the names out of the filter/formula. 

The output I am expecting:

AMD CENTER

Bi Industries

CZ INDUSTRIES

D I S COMPANY

A AND B HOMES CO

Hi CENTER

Can anyone help with a workflow? Thanks!

[spencer046]

I am not. I was also experiencing some duplication with a single word, with more than 4 letters. However, I was able to resolve both of the issues by breaking down the formula into two parts. Thank you for all your help!