Do you know any formula to delete accents?
Eduardo,
It's not as easy as taking an eraser to the accent mark. Each character
that has an accent is just that, a single character. You'd have to
replace each character with another character.
I think amontes has a good idea, an you'd have to complete the list to
include any other accents you might want to change. The SUBSTITUTE
formula would work, as long as you can fit all the changes you need into
it,
G'Luck!
Eduardo Pinto wrote:
I have a big database and to export I need to clean all accents, for example
the word Jerónimo I need it without accents Jeronimo, do you know any formula
to do that?
Thanks
Regards
|