I have a list of notes for our accounts that contain proprietary code. I have exported these notes to excel and I want to find all the accounts that have the specific line of code below.
<font size="+.25"><font color="blue"><b> Received %50 Down</b></font>
Part of the problem is that the cells may contain other information. I want to use an if statement to return a 1 if the code is in the cell and 0 otherwise. I tried using a wildcard but I think the " and >< characters are messing it up. See the attached file, I need a solution!
=IF(D2="*<font size="+.25"><font color="blue"><b> Received %50 Down</b></font>*",1,0)
Did NOT work
Thanks
Bookmarks