February 25, 2026•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?

Check out the full article on the original site

#Excel alternatives for data analysis

#generative AI for data analysis

#natural language processing for spreadsheets

#big data management in spreadsheets

#conversational data analysis

#real-time data collaboration

#intelligent data visualization

#rows.com

#Excel compatibility

#record label

#remove accents

#special characters

#revenue data

#expense data

#artist names

#harmonize

#data set

#data harmonization

#data analysis

#data cleaning