Highlight Foreign Characters

[RAguilar]

Hi everyone new guy here, I just want to ask if there's a way I can highlight all the foreign characters like Japanese, Chinese character etc... ?



Thank you in advance..

[noboffinme]

Hi RAguilar,

Do you a have list of all potential characters that you want to highlight?

You could then use a Find Function & Conditionally format them.

Or a Macro could do the above.

Just a thought.

[FDibbins]

Pretty much CHAR(65) to CHAR(128) covers a-z and A-Z, so maybe you could use something like =AND(CODE(cell-ref)>=65,CODE(cell-ref)<=128)...this would give the english alphabet

[WHER]

Based on a UDF i picked up on here (can't find the thread anymore):

Please Login or Register  to view this content.

[RAguilar]

Based on a UDF i picked up on here (can't find the thread anymore):

Please Login or Register  to view this content.

This one works.. Thank you all very much for your help! Very much appreciated