+ Reply to Thread
Results 1 to 4 of 4

DELETE ROWS WITH FOREIGN CHARACTERS/Words (e.g Chinese & Arabic)

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    Smile DELETE ROWS WITH FOREIGN CHARACTERS/Words (e.g Chinese & Arabic)

    Hi, I was wondering if there is a way to delete all rows with foreign language in excel. I attached a sample data. All highlighted in yellow should be deleted as they contain non-english characters. hope you could help me with this.


    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: DELETE ROWS WITH FOREIGN CHARACTERS/Words (e.g Chinese & Arabic)

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-29-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: DELETE ROWS WITH FOREIGN CHARACTERS/Words (e.g Chinese & Arabic)

    Wow!! you are heaven sent Karedog! Thank you so much. This works perfectly!! :-)

    Quote Originally Posted by karedog View Post
    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: DELETE ROWS WITH FOREIGN CHARACTERS/Words (e.g Chinese & Arabic)

    You are welcome thalyn_yang, glad I can help.


    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Identify cells that contain foreign (Chinese, Japanese) characters?
    By MetroBOS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-27-2015, 06:20 PM
  2. Spell Numbers to arabic Words
    By Amrbahgat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2014, 03:10 AM
  3. [SOLVED] Delete from a cell all words shorter than N characters
    By Buzzed Aldrin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-10-2012, 10:06 PM
  4. [SOLVED] Replace Random Chinese Words (Not Characters) with Blank Spaces in MS Word
    By mlexcelhelpforum in forum Word Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2012, 06:42 AM
  5. [SOLVED] How to eliminate rows with foreign text characters ?
    By Mark53 in forum Excel General
    Replies: 4
    Last Post: 05-18-2011, 05:35 PM
  6. Using foreign characters
    By Victor in forum Excel General
    Replies: 1
    Last Post: 06-02-2006, 02:15 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