Jul 09 2019 01:54 AM
Hello Everyone ,
can anyone guide me how i can filter special characters in excel, for eg . ŞTI TİC. etc.
thank you.
Jul 09 2019 02:17 AM
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
Jul 09 2019 03:54 AM
Jul 09 2019 05:22 AM
You may use Advance Filter
For such sample
keep B1 empty and in B2 formula
=(SUMPRODUCT(--(UNICODE(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))>=132))>0)
which checks if in text are any non-ascii characters - UNICODE()>=132
After that select your entire range in column A, Data->Advanced Filter and here
You may filter in place, but better to copy filtered data into new column.