Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replace foreign chars (2003)

    Hi. I have a column of french names. How can I replace accented characters with their english equivalent? For example, replace with e.
    I can do this individually using Edit/Replace, but is there a way I can do this with a collection of characters? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Replace foreign chars (2003)


  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replace foreign chars (2003)

    Thank you. Although I think an Excel solution (rather than VBA) is required. Andy.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Replace foreign chars (2003)

    You could modify the procedure (sub) and create a custom function that can be used in worksheet formulas.
    Otherwise you're stuck with lots of individual replace actions, I fear.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •