00:00Can you imagine I get asked this question quite a lot?
00:03How do you search for a word in a sentence?
00:06In particular, compound words like butterfly,
00:09which is a combination of both butter and fly.
00:12Another one is like handwriting or overload.
00:16I think you get the point.
00:17Well, this is how I do it.
00:18We're going to start off by using a text split function.
00:21I'm going to say equal text split.
00:23And then the first argument would be your statement itself,
00:25which is going to be from cell B5 like this.
00:28And the second argument would be space, which is our delimiter.
00:32So essentially what this does is that it takes the sentence in cell B5
00:36and splits into an array like this in every cell horizontally.
00:41Now, what we can do is basically look for the word butter in cell C5
00:45by encapsulating your text split with an or function.
00:48Let me demonstrate.
00:49Go back to your formula.
00:50You're going to say or, open parenthesis.
00:53We're basically looking for value in cell C5, close parenthesis, and hit enter.
00:59This is false because there's no butter.
01:02There is butterflies, but there's no butter itself.
01:05Now, if you take the same formula and paste it below,
01:08and this statement here in cell B6 has the word butter itself,
01:13that's why it's returning true.
01:14Let's apply the same formula for the rest of the rows.
01:16I recognize that text plate function is only available in Microsoft 365,
01:22but in my next video, I'll demonstrate how you can do the same thing
01:25in all versions of Excel.
01:27Stay tuned.
