Stripping Out Foreign (Chinese) Characters

[Steve]

Hi Folks

I'm on a project where I am using about 10 large spreadsheets which are being
sent to me updated weekly.

99% of the data is just text but the trouble is that the contents of each cell
has both the English and the Chinese translation usually seperated by a [HARD
RETURN] although the order isn't consistent i.e. sometimes it's ENGLISH [HARD
RETURN} CHINESE other times it's CHINESE [HARD RETURN} ENGLISH

Is there a way to automatically strip out the Chinese characters and ideally rhe
[HARD RETURN] so that I can link the table into MS Access

Thanks

Steve