NCISabbyfan
Posts: 95 +0
I am familiar with the general usage of the IF function, but how do you search for text within text?
For instance, I know how to instruct IF to locate a complete sentence in a cell, but am unsure how to instruct IF to find specific text, such as:
Excel 2007 - Searching for individual words within a block of text
Just as an example, I wanted to find cells that contained say "block of text", not the whole sentence, how do I go about this?
For instance, I know how to instruct IF to locate a complete sentence in a cell, but am unsure how to instruct IF to find specific text, such as:
Excel 2007 - Searching for individual words within a block of text
Just as an example, I wanted to find cells that contained say "block of text", not the whole sentence, how do I go about this?