I have a pivot table with item numbers for rows and financial periods for columns. I want to filter the item numbers.
I have items number that are 3 letters, a hyphen, then 5 integers. Example: VIP-69075
And I have item numbers that are 2 letters, a hyphen, then 4 integers. Example VI-3501
I want a filter that will show me all the items with digits beginning “3” but only the 2-letter ones. I can ask for Starts With VI-3 and I can ask for Contains -3 but neither shows me exactly what I’m looking for, which would be Starts With __-3, but that doesn’t yield any results for me. (I need to indicate a wild card of precisely 2 characters.) Is there a way to do this?