Atul Rajratna
New Member
Hi Team,
I am looking for the formula, where I can find non-ASCII characters (non-supportive special characters) from the email address.
I tried using "=OR(IF(MID(A1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1))),1)>"a",1))" from Chandoo's forum but could not get the exact result.
We are facing lots of problem due to invalid email IDs and getting so many rejects from client end.
e.g -
á
â
ñ
ò
ø
ù
ü
ý
þ
ë
ì
Þ
ß
à
and many more..
so we can use the list of such special characters using =char()
usually we get email id's like-
sàm.morels@xyz.com
ve©tor@lkjh.com
tim.howârds@qwerty.com
atlasbi@žxcv.com
Here you can see special characters in the username & in the company name (excluding _-.@) which are completely non-supportive characters.
And due to high count we can't find-out such email IDs and get bounce back errors while sending email.
So please help me in this!
-Atul Rajratna
I am looking for the formula, where I can find non-ASCII characters (non-supportive special characters) from the email address.
I tried using "=OR(IF(MID(A1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1))),1)>"a",1))" from Chandoo's forum but could not get the exact result.
We are facing lots of problem due to invalid email IDs and getting so many rejects from client end.
e.g -
á
â
ñ
ò
ø
ù
ü
ý
þ
ë
ì
Þ
ß
à
and many more..
so we can use the list of such special characters using =char()
usually we get email id's like-
sàm.morels@xyz.com
ve©tor@lkjh.com
tim.howârds@qwerty.com
atlasbi@žxcv.com
Here you can see special characters in the username & in the company name (excluding _-.@) which are completely non-supportive characters.
And due to high count we can't find-out such email IDs and get bounce back errors while sending email.
So please help me in this!
-Atul Rajratna