I am stumped with wild cards.
I have col F which has text entires.
Example Col F:
In NIGHT TIME
My end goal is to count the entries in col F that contain the word
NIGHT, but the wildcards are not working for me. The above example would be 4.
The following formula works for entries of just NIGHT alone
But I would like to count those cells that may have NIGHT in the middle of text, beginning or at the end.
<== NOTE there should be an asterisk before and after periods in the string although they are not showing up in the post. (Edited for readability: The asterisks are present now. Use the code tool.) (Editing again: See also the comment by the OQ below.)
Returns nothing in the box.
Office Libre Ver. 126.96.36.199
I am sure this is something simple but after 4 hours of messing and searching for an answer, I give up.