I am trying to Autofill a cell with the information from another cell.

For example if a cell in column A contains the word TESTER in the sentence.
I want to get the Word Tester in column B to classify that product as a
Tester.

Thanks