Results 1 to 2 of 2

Accented Characters Search

Threaded View

ImranBhatti Accented Characters Search 05-10-2018, 07:47 PM
ImranBhatti Re: Accented Characters Search 05-11-2018, 01:31 PM
  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Accented Characters Search

    Hi

    In the attached screenshot of web It is shown that if I type letter A ,it highlights all the As and À's and a 's without any distinction.
    and it is two way (I mean if I type À it highlights all the As and Às)
    Can This be done in Excel? (Bothway)

    What I really want is to filter a dataset that has accented characters (there is a lot of great work by the programmers on the web to convert accented to normal(example:https://www.excelforum.com/excel-pro...-a-string.html).
    but I also need to retain the accented characters on the worksheet as the data is required in the original language.

    Help would be greatly appreciated

    Best Regards
    Imran Bhatti
    Attached Images Attached Images
    Last edited by ImranBhatti; 05-10-2018 at 07:51 PM. Reason: attachment was missing
    Teach me Excel VBA

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Accented to Non Accented and Non Accented to Accented mapping
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2018, 04:00 PM
  2. [SOLVED] Replace accented characters in worksheet name to regular characters
    By kingsdime29x in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2017, 10:59 AM
  3. [SOLVED] How to ignore accented characters in a string
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-17-2017, 01:36 AM
  4. Macro to find and replace accented characters.
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2014, 02:08 AM
  5. [SOLVED] Conditional replace accented characters with non-accented ones
    By greek in forum Word Programming / VBA / Macros
    Replies: 15
    Last Post: 04-22-2014, 09:41 PM
  6. [SOLVED] Replace/remove accented characters
    By guest2013 in forum Excel General
    Replies: 3
    Last Post: 08-19-2013, 01:46 AM
  7. Sort on accented (French) characters
    By greek in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-30-2011, 06:43 AM

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