remove all non-English characters, special characters, necessary - Microsoft Community
Office / Excel / Windows 10
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
Post a Comment