remove all non-English characters, special characters, necessary - Microsoft Community


i have string (80k) of descriptions alphanumeric , contains chinese characters well. 

examples:

0103�� 9120 90 10 千克≤重量<50 千克的其他猪(改良

10 50 13 5 千克/ 头 ̄ ̄ ̄Weighing 10kg 

i need able clean these by:

a) removing non-english characters

b) remove special characters

c) remove spaces between numbers

expected results (in adjacent cells):

01039120901050

1050135 weighing 10kg

non-english can outside of 0-9 , a-z. 



Office / Excel / Windows 10



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

What is the Office 365 default group Mailbox Users ISV Access Enabled - Microsoft Community