Convert special characters to HTML entities. HTML entity encoder converts special chars into HTML entities and vice versa.
Just select the text that you want to convert, then go to "Add-ons > HTML entity encoder > Encode" and special chars will be replaced by HTML entities.
For example:
"&" will be replaced by "&"
"á" will be replaced by "á"
"!" will be replaced by "!"
If you want to convert HTML entities into special chars, select the text that you want to convert, then go to "Add-ons > HTML entity encoder > Decode" and HTML entities will be replaced by special chars.
More info about HTML entities:
https://www.w3schools.com/html/html_entities.asp
Reviews of HTML entity encoder - Google Sheets add-on platform_app