Remove Chinese text from cells.

Hi folks, I am new to the forum and navigating my way around, so please bear with me.
I have a spreadsheet that has Chinese characters mixed with English. I need to get rid of the Chinese, any suggestions? I have tried oldchippy's suggestion on another thread and I get #Value!
I cannot post a link to the original thread as I haven't posted enough times.

This is an example of the string in cell A1.

All-in-one Shopping Destination at 日本東京都渋谷区宇田川町１５−１ 渋谷PARCO

Many thanks.

I am using Excel for Mac
Version 16.13.1
Office 365 Subscription

.
Paste this into a Routine Module. This is untested here :

Please Login or Register  to view this content.

The macro, when run, will ask for a range. Highlight that range, then click OK.

Many thanks Logit, it worked a treat.

.
Great ! Glad it worked.

Sorry to take so long to respond. The FORUM servers are acting up for me and not auto notifying me when an update has been posted.

Cheers.