S
Sonja
How can I remove french accents from a large amount of data?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
Have you tried using Edit | Replace (CTRL-H) a few times? Highlight
the block of text first.
Hope this helps.
Pete
the block of text first.
Hope this helps.
Pete
J
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
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
S
Sonja
This worked. Not as easy as I would have hoped, but it works. Thanks for
your help John!!
your help John!!
J
John
Life is not always easy!!
You're welcome
You're welcome
Sonja said:This worked. Not as easy as I would have hoped, but it works. Thanks for
your help John!!
D
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
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