A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Most likely some of those items have trailing spaces or other hidden characters at the end. If you use "*"&AB1&"*" as the criteria, does that fix it?