Hi,

I've been dabbling in some regular expressions in vba while reading files.

Can someone help me with the syntax for a foreign character regular expresssion.

I'd like to catch instances of these sorts of characters : ÐÏࡱá.

I've tried "[0-9a-bA-B]" so far which is fine but I lose important characters like + - , : ( ) % etc. These foreign characters are as a result of file e.g a .xls file turned into a .txt file and data is corrupted but still shows.

Alternatively is there a way to detect these without regular expressions?

Thanks in advance.