Need Data entry help with spreadsheet - 3500 entrees

Job ID: 34134188

Budget: $10 – $30 USD

We have a spreadsheet with 3500 entries. There is a single column on this sheet that needs to be updated.
The cells in this column should list company names but instead, they list hundreds of variations of various companies with additional characters.

So, if a cell contains a word, the entire cell contents needs to be replaced with a specific company name.

Example: If the cell contains the word "Donaldson" then the entire cell needs to be replaced with "Donaldson Torit"