Forum Discussion
Jbalas
Sep 11, 2023Copper Contributor
Filtering * and ? in a pivot table
I have a set of data that ends with an * , If i try to filter it Excel consider this characters as any and does not filter anything. how can I explain to filter exactly the "*"
- Sep 11, 2023
Use ~* to filter items containing an asterisk, and ~? to filter items containing a question mark.
HansVogelaar
Sep 11, 2023MVP
Use ~* to filter items containing an asterisk, and ~? to filter items containing a question mark.