•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to remove accents and other special characters from data set?
Hi everyone. I work for a record label. We get a set of revenue and expense data from each month for me to analyze.
Problem is the revenue data includes special characters in artist names. I want to harmonize it so it’s the same as expense
For Example:
REV: Cèline Dion, EXP: CELINE DION
Rev: TRØVE, EXP: TROVE
Any way to do this, it would make my job a lot easier?
[link] [comments]
Want to read more?
Check out the full article on the original site