View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default REMOVE FRENCH ACCENTS

Life is not always easy!!
You're welcome
"Sonja" wrote in message
...
This worked. Not as easy as I would have hoped, but it works. Thanks for
your help John!!

"John" wrote:

Hi Sonja
I don't have a quick way to do this but accents in french are mostly "é è Ã* "
so
you can goto Edit Find press and hold the Alt key and type on the numeric
keypad 0233 and replace type e ( Alt-0233 is é ) (Alt-0232 is è ) (Alt-0224
is
Ã* ) don't forget to type the proper letter in "Replace with"
HTH
John
"Sonja" wrote in message
...
How can I remove french accents from a large amount of data?