If row in column contain word, insert text next column

Closed
Tony Tomison Posts 1 Registration date Wednesday November 7, 2012 Status Member Last seen November 7, 2012 - Nov 7, 2012 at 12:52 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 7, 2012 at 04:41 PM
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!

Related:

1 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Nov 7, 2012 at 04:41 PM
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.
0