Results 1 to 16 of 16

Conditional replace accented characters with non-accented ones

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-09-2009
    Location
    Greece
    MS-Off Ver
    Office 365
    Posts
    133

    Conditional replace accented characters with non-accented ones

    I want to be able to correct a specific type of mistake in Greek (free) text. For any word that starts with an accented vowel or εύ, if there is anywhere in that word another instance of an accented vowel, then replace the first instance with the non-accented counterpart of that vowel. It should respect capitalization and replace with the capital counterpart in case it is capital.

    (In the attached file, 3 sheets, 1 with vowel list, 2 with example replacements, 3 with free Greek text with words for correction).

    For example

    Find Replace
    άγώνας αγώνας
    άδελφός αδελφός
    άερόστατο αερόστατο
    άθέτησις αθέτησις
    εύρέσεως ευρέσεως
    εύρύτης ευρύτης
    εύχέλαιο ευχέλαιο

    Accented Non-Accented
    ά α
    έ ε
    ή η
    ΐ ι
    ϊ ι
    ί ι
    ό ο
    ύ υ
    ΰ υ
    ώ ω
    εύ ευ
    Attached Files Attached Files
    Last edited by greek; 04-23-2014 at 05:17 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Replace/remove accented characters
    By guest2013 in forum Excel General
    Replies: 3
    Last Post: 08-19-2013, 01:46 AM
  2. [SOLVED] find and replace to not replace characters found as wildcards
    By sabutler4 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 06:48 PM
  3. Macro to replace European characters with non "special" English characters?
    By johanna0507 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2012, 09:13 AM
  4. Sort on accented (French) characters
    By greek in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-30-2011, 06:43 AM
  5. How do I replace just a few characters?
    By Tomsriv in forum Excel General
    Replies: 3
    Last Post: 08-14-2006, 07:09 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1