Forum Discussion
how to filter special characters in Excel
Hello Everyone , can anyone guide me how i can filter special characters in excel, for eg . ŞTI TİC. etc. thank you.
Hello Tauqeer ,
Thank you for swift reply , but seems this doesn't work with my criteria.
I have more than 10,000 rows from which i need to detect those columns only which contain anything except English Alphabets .
EG. ALTİNTAS NAKLİYE VE VİNC İSLETMECİLİGİ
Thank you for swift reply , but seems this doesn't work with my criteria.
I have more than 10,000 rows from which i need to detect those columns only which contain anything except English Alphabets .
EG. ALTİNTAS NAKLİYE VE VİNC İSLETMECİLİGİ
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.