+ Reply to Thread
Results 1 to 4 of 4

how to split English and Arabic character?

  1. #1
    Registered User
    Join Date
    08-21-2015
    Location
    Manchester
    MS-Off Ver
    13
    Posts
    14

    how to split English and Arabic character?

    Hi all,
    does anyone has a solution for separate Arabic and English character by using formula or Macro for below these letters as I have big files so can't use find, text to column or some other formulas, please share your great ideas, highly appreciated your wonderful answer.

    خل vinegar خل
    green salad سلطة خضراء
    مربع الكرز cherry box
    Strawberry box مربع الفراولة
    avacado أفاكادو جنوب أفريقيا south africa
    mushroom فطر النيوزلندية
    green apple تفاحة خضراء

    Thanks,

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: how to split English and Arabic character?

    Have you by chance looked at this post?
    http://www.excelforum.com/excel-form...-two-cell.html
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    08-21-2015
    Location
    Manchester
    MS-Off Ver
    13
    Posts
    14

    Re: how to split English and Arabic character?

    thanks for your quote, those formula doesn't work if there are Arabic character between the English letters. however it has been solved
    by Mr. MickG.

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: how to split English and Arabic character?

    Glad you got it worked out.

+ 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. split between arabic and english in one cell into two cell
    By basstk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-27-2022, 08:07 AM
  2. how to convert the text in a column from arabic to english language
    By grk2006 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2015, 06:45 AM
  3. How to convert numbers from Arabic to English
    By voltaire101 in forum Excel General
    Replies: 5
    Last Post: 08-08-2015, 12:54 PM
  4. Need to translate from Arabic language to English
    By gaminguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2013, 09:27 AM
  5. Need to translate from Arabic language to English
    By gaminguy in forum Excel General
    Replies: 1
    Last Post: 01-10-2013, 05:22 AM
  6. How do I get Arabic numbers converted to English text format?
    By Kantoo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2006, 12:10 AM
  7. Convert arabic number to english text
    By TSK in forum Excel General
    Replies: 2
    Last Post: 07-09-2005, 06:05 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