REMOVE FRENCH ACCENTS

[Sonja]

How can I remove french accents from a large amount of data?

 

[Pete_UK]

Have you tried using Edit | Replace (CTRL-H) a few times? Highlight
the block of text first.

Hope this helps.

Pete

 

[John]

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]

This worked. Not as easy as I would have hoped, but it works. Thanks for
your help John!!

 

[John]

Life is not always easy!!
You're welcome

This worked. Not as easy as I would have hoped, but it works. Thanks for
your help John!!

 

[Dave Curtis]

Hi Sonja,

Here's another idea you may wish to consider.
You can use a nested substitute function to replace more than one character
in a cell at a time. I've only set it up for e (grave), e (acute), e
(circumflex), a (grave) and a (circumflex), but you can nest up to three
more. I think it limits it to 8.
if your data starts in A1, then in B1 enter

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3,"è","e"),"é","e"),"ê","e"),"â","a"),"à","a")

and drag down..

Dave