Filtered column not showing relevant data
I am trying to filter a column on an item number. I create a new filter on the 'Product' column with the 'contains' condition and enter the item number as the value. The filter returns no results. If I paste that same exact item number into the Search bar in the top right corner of the webpage and filter the location to 'Current Sheet' the row is found. What am I doing wrong with the filter for it to not find the row that clearly exists?