Hi All
I have a small doubt.
Let us say I have the following text in Cell A1. "There is a fault in the cal cycle.Need to update the records."
And in cell A2 I have the following text. "Called for backup assistance. There is an issue with numbers."
I cells B1 & B2 I need a particular formula which searches for the substring "cal" exactly and returns true if present. In cell A1, we have "cal" in the text. So it should return true for me in cell B1.
However in cell B2 I need false to be returned even though I have "Called" inside the text. I need true to be shown only for those cells where we have the exact text "cal" and no text characters in front or back of it.
Is there any solution to this?
Thanks in advance!
Bookmarks