Hi all,
does anyone has a solution for how to separate Arabic and English characters by using formula or Macro for below these letters as I have big files so can not use find, text to column or some other tricks, please share your great ideas, highly appreciated your wonderful answer.
خل vinegar خل
green salad سلطة خضراء
مربع الكرز cherry box
Strawberry box مربع الفراولة
avocado أفاكادو جنوب أفريقيا south Africa
mushroom فطر النيوزلندية
green apple تفاحة خضراء
Thanks,
you can use:
Please Login or Register to view this content.
Last edited by bulina2k; 08-22-2015 at 10:04 AM. Reason: complete code
.. and don't forget to have fun!
Bogdan.
mark SOLVED andAdd Reputation if my answer pleases you
Try this:-
Results separated into columns "A"and "B"
Regards MickPlease Login or Register to view this content.
Last edited by MickG; 08-22-2015 at 10:31 AM.
wow wow awesome, fantastic, you are the BOSS! thank you so much Mr. MickG!!!
Hi Reeya Try this
It deals with Arabic letters , Numbers and English letter (each in column)
Please Login or Register to view this content.
Last edited by YasserKhalil; 08-22-2015 at 01:34 PM.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks