Hi!

Try this:

=IF(ISNUMBER(SEARCH("USDA",C1)),1,"")

Biff

"brantty" wrote in message
...
I have a large document where in column C contains a sentence. I need a
formula that will look in Column C, identify the word "USDA" and populate
a
new column with a 1. Can anyone help me with this?