+ Reply to Thread
Results 1 to 4 of 4

Remove English language text in excel and retain foreign language.

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    india
    MS-Off Ver
    MS office 2007
    Posts
    2

    Remove English language text in excel and retain foreign language.

    How to remove English language from an excel sheet having two different languages.
    This code worked for me to remove foreign language
    Please Login or Register  to view this content.
    but how to remove English language and keep the foreign text.I don't have any idea about VBA. I just started now and found this code in some thread.Thanks in advance.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Remove English language text in excel and retain foreign language.

    Change the pattern
    Please Login or Register  to view this content.
    But it will also remove:
    space
    comma
    period
    hyphen

    Is that how you wanted?

  3. #3
    Registered User
    Join Date
    07-30-2014
    Location
    india
    MS-Off Ver
    MS office 2007
    Posts
    2

    Re: Remove English language text in excel and retain foreign language.

    No.actually i only wanted to remove English text.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Remove English language text in excel and retain foreign language.

    Please Login or Register  to view this content.

+ 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. Remove Foreign Language
    By msliedrecht in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-27-2021, 11:33 AM
  2. Calling Worksheet Functions in a Foreign Language Version of Excel
    By drobles in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2009, 12:30 PM
  3. Covert the text in the Excel from English to other language
    By abiram01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2009, 10:00 AM
  4. Replies: 0
    Last Post: 05-02-2006, 07:55 PM
  5. Excel in a foreign language
    By nsv in forum Excel General
    Replies: 1
    Last Post: 02-16-2006, 10:40 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