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

See if this works for you:

=IF(COUNTIF(A1,"*tester*"),"tester","")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Gmata" wrote in message
...
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