I have a spreadsheet with about 5,000 rows andjust one column - column A. I
would like to record a formula in column b where for every cell in column A
that contains the word "web" somewhere in the description (the description
could have up to 10 words), it will place the number "1" in column B. Can
this be done?

I assume that it is some sort of if/then statement, but when I try
=IF(A2="*web*",1,0) with the wild card "*" it does not seem to work. Any
ideas?

Thank you,
Paul