I cannot figure out a formula to replace specific characters in a cell by values from a table.
This wonderful forum has already helped my find a great solution in VBA.
Despite that I would like to find a way to do the same with a formula.
République > Republique
I have a table with the special characters and the replacement characters.
Attached file contains the table and some example texts.
(not all cells have special characters)
Can somebody help me create the formula?