Remove accent via formula in Google Sheets

Asked

Viewed 6,307 times

1

I need to remove diacritical signals (accentuation and cedilla) in the values of a column in Google Sheets. I know that it is possible and easier to solve this problem through an App Script function, however this is a situation as much as normal for me, I am not always free to install the script in certain spreadsheets. Therefore, I would like to solve this problem through a formula, perhaps with regex.

The answer accepted of that question presents a possible path, but serves a purpose other than mine. Moreover, this question was answered two years ago.

What would be possible gambiarras for my problem?

Documentation: https://support.google.com/docs/answer/3098245?hl=pt

Note: I believe the question is relevant, because the possible solutions will depend on Regex.

regex google-sheets
  • 4

    Have you tried =REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(A2;"[ùúüû]";"u");"[èéêë]";"e");"[àáãâäå]";"a");"[íìîï]";"i");"[óòöôõ]";"o");"ç";"c")? And with capital letters, just add them in the same way. Anyway, with script it would be better...

1 answer

4


That function was TOP!

I just added the capital letters:

=REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(C2;"[ùúüû]";"u");"[èéêë]";"e");"[àáãâäå]";"a");"[íìîï]";"i");"[óòöôõ]";"o");"ç";"c");"[ÙÚÜÛ]";"U");"[ÈÉÊË]";"E");"[ÀÁÃÂÄÅ]";"A");"[ÍÌÎÏ]";"I");"[ÓÒÖÔÕ]";"O");"Ç";"C")

Browser other questions tagged regex google-sheets

You are not signed in. Login or sign up in order to post.