I recieve a spreadsheet from France, Russia, and Saudi Arabia separately. The description field always contains the English and the Non-English verbage separated by numerous spaces, return characters and or special characters. Sometimes the Non-English verbage is first sometimes the English verbage is first. The length of each is also variable.
I need to remove the Non-English verbage while leaving the English verbage. I have looked all over and can not find how to do this. I would share the spreadsheet but that data is sensitive.
Please assist if up to the challenge