HienFerber
New Member
- Joined
- Feb 24, 2018
- Messages
- 6
I have a data with a column full of duplicated values like the example in my title. I know we can use TRIM function to remove the space, but there are records like "South America" with a valid space so I can't apply TRIM for all. Also, there are so many examples like * Yunnan* that it is very tedious to fix the duplications one by one. There must be another way to address this problem? Thank you in advance for your help!