Mutiple languages in cells

[uk17340]

I have some excel documents at work that were originally in Japanese but have been translated into English.
Majority of the cells in the worksheet have one line of English with a line of Japanese after it.
Is there any way the Japanese characters can be removed leaving only the English phrase in the cell.
There are some cells that also contain numbers and I would like to remove only the figure next to the Japanese text.

I've attached an example

Thanks in advance

[Marc L]

Please Login or Register  to view this content.

If you like, increase my reputation !

[Marc L]

Please Login or Register  to view this content.

If you like, increase my reputation !

[uk17340]

Both sets of code work on the example but not on the actual document.
Attached is one of the documents that I'm working with, please ignore text boxes that contain Japanese text I can sort these out manually.

Thanks all