REMOVE FRENCH ACCENTS
 

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

REMOVE FRENCH ACCENTS
 

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

Hope this helps.

Pete

On Feb 17, 2:23*pm, Sonja wrote:
How can I remove french accents from a large amount of data?

REMOVE FRENCH ACCENTS
 

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?

REMOVE FRENCH ACCENTS
 

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?

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?

REMOVE FRENCH ACCENTS
 

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(SUBST ITUTE(A3,"è","e"),"é","e"),"ê","e"),"â","a")," Ã*","a")

and drag down..

Dave


"Sonja" wrote:

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