Replacing Letters with Accents

Hello,

You can create a function in powerquery that converts all column. 

Open a blank query e paste this: 

(Texto as text) =>
let
    ListAccents = 
		{
		{"à","a"},
		{"á","a"},
		{"â","a"},
		{"ã","a"},
		{"ä","a"},
		{"è","e"},
		{"é","e"},
		{"ê","e"},
		{"ë","e"},
		{"ì","i"},
		{"í","i"},
		{"î","i"},
		{"ï","i"},
		{"ò","o"},
		{"ó","o"},
		{"ô","o"},
		{"õ","o"},
		{"ö","o"},
		{"ù","u"},
		{"ú","u"},
		{"û","u"},
		{"ü","u"},
		{"À","A"},
		{"Á","A"},
		{"Â","A"},
		{"Ã","A"},
		{"Ä","A"},
		{"È","E"},
		{"É","E"},
		{"Ê","E"},
		{"Ë","E"},
		{"Ì","I"},
		{"Í","I"},
		{"Î","I"},
		{"Ò","O"},
		{"Ó","O"},
		{"Ô","O"},
		{"Õ","O"},
		{"Ö","O"},
		{"Ù","U"},
		{"Ú","U"},
		{"Û","U"},
		{"Ü","U"},
		{"ç","c"},
		{"Ç","C"},
		{"ñ","n"},
		{"Ñ","N"}
		}
in
    Text.Combine(List.ReplaceMatchingItems(Text.ToList(Texto), ListAccents))

Please try this:  https://stackoverflow.com/q/71969831/6165594

= (textToConvert) =>
let 
    textBinary = Text.ToBinary  (textToConvert,              1251 ),
    textASCII  = Text.FromBinary(textBinary   , TextEncoding.Ascii)
in    
    textASCII

Hello Anonymous look this:

https://docs.microsoft.com/en-us/powerquery-m/text-trim 

Hi,

If you want to replace letters with accented versions in a word or sentence, you can use a word processor or text editor that supports special characters. In most word processors, you can insert accented characters by holding down the "Alt" key and typing a specific code on the numeric keypad. For example, to insert an é, you can hold down the "Alt" key and type "0233" on the numeric keypad.

Another option is to use a tool that provides a virtual keyboard with accented characters. You can use your mouse to click on the desired accented character, and it will be inserted into your document.

If you want to programmatically replace letters with accented versions in a string, you can use a library or a function that supports character encoding and mapping. For example, in Python, you can use the "unicodedata" library to map characters to their accented versions using the "normalize" and "translate" functions.