Forum Discussion

Jbalas's avatar
Jbalas
Copper Contributor
Sep 11, 2023
Solved

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 "*"
  • HansVogelaar's avatar
    Sep 11, 2023

    Jbalas 

    Use ~* to filter items containing an asterisk, and ~? to filter items containing a question mark.

Resources