Find Text in a cell

[smak]

I have a sheet that has cells with lots of text. I want to search the cell and see if the text exists.

Below is the type of data I have. For reference, assume this is columns A and B and row 1(header) and 2 (text I need to search)

I used Countif to search for "*active" in the range below and it found it. I realize that "*Active" is the only thing in its respective cell.

But if I search for the word "Project" in the same range, it does not find it. I suspect it is because "Project" is part of a cell that has a lot of text.

How do I search the range for the word "Project" to see if it is there. I am hoping to do a formula.

..................... A................................................................B

Project_Status	milestones
• Active	Project Started : 03/16/2023 - 03/16/2023 Initiation : 03/16/2023 - 03/20/2023 Testing (ITE) : 03/16/2023 - 01/01/2024 Planning and Scoping : 03/21/2023 - 04/03/2023 Design : 04/04/2023 - 05/25/2023 Implementation (PROD) : 04/14/2023 - 08/26/2024 Closeout : 08/27/2024 - 08/30/2024

 

[Fluff]

You can use wildcards in countifs like

=COUNTIFS(B:B,"*project*")

 

[smak]

That worked.

I have a second part to the question. if in cell C5 there is a word/text (for this example it is the word "Closeout").

I want to do the countif/Search with the value of the cell C5. How do I search for the cell value

 

[Fluff]

Like

=COUNTIFS(B:B,"*"&C5&"*")

 

[smak]

Thank you, that worked great

 

[Fluff]

You're welcome & thanks for the feedback.