1 min readfrom 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?

submitted by /u/DrIronclaw
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article