One way:

=IF(ISNUMBER(SEARCH("rostering",A1)),"R","")

Copy down as needed.

Biff

"LucB" wrote in message
...
Hi,

I have 1000 comments in column A, one comment cell. In column B against
each
comment I want to do a formula that returns a value (say 'R') if the word
'Rostering' appears in it.

Could someone please provide me with the correct 'IF' statement or any
alternatives?

Thanks
--
.