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!

1 reply

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