how to filter special characters in Excel

Hi Hasnain,

You can use 'custom filter' option available in filter option to find text with special characters.

You just need to place ~ before the special character you want to filter.

Thanks

Tauqeer