Do you know any formula to delete accents?
Say you have text in column A and want each occurance of:
ó
with
o
In B1 enter:
=SUBSTITUTE(A1,CHAR(243),CHAR(111))
and copy down
Then copy column B and paste/special/values back onto column A
You must repeat the above for each letter of the alphabet whose accent you
want to remove.
It might be easier with a macro.
--
Gary''s Student - gsnu200812
"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
|