If row in column contain word, insert text next column

[Closed]
Report
Posts
1
Registration date
Wednesday November 7, 2012
Status
Member
Last seen
November 7, 2012
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Hello,

I have an excel files, and in column B I have a file path, but if it contains a specific word like "proprietary" I need to insert into the row next to it, "True"

Please help!

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
Hi Tony Tomison,

Insert this formula in Column C:

=ISNUMBER(SEARCH("proprietary",B1))

This will insert a TRUE in C1 if the B1 contains the text "proprietary".

Do reply with results.