+ Reply to Thread
Results 1 to 11 of 11

Change Arabic Characters to English - As per given transliteration table (PFA)

  1. #1
    Registered User
    Join Date
    12-26-2018
    Location
    India
    MS-Off Ver
    2017
    Posts
    17

    Change Arabic Characters to English - As per given transliteration table (PFA)

    Dear Team Members ,

    Good day.

    Kindly go through the attached excel file. I need to take just first 5 characters from arabic to english as per given transliteration table..


    Kindly help me in this
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)


    Hi !

    Just elaborate and give an example of an expected result from a source data …

  3. #3
    Registered User
    Join Date
    12-26-2018
    Location
    India
    MS-Off Ver
    2017
    Posts
    17

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)

    Dear Marc,

    Please find the attached file in the main thread. I've 2 things

    No 1 is Title
    No 2 is Author

    and I need Title and author cutter of first five letters from the give title and author data.

    Those five letters must be in roman characters as per given transliteration table.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)

    Quote Originally Posted by Marc L View Post
    Just elaborate and give an example of an expected result from a source data …
    So where is the expected result within your attachment ?!

  5. #5
    Registered User
    Join Date
    12-26-2018
    Location
    India
    MS-Off Ver
    2017
    Posts
    17

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)

    Expected results (5 roman characters )are under the heading "Author_Cutter" and Title_Cutter"

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)


    As I can't reach any expected result maybe someone else may help …

  7. #7
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,708

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)

    Hey rameshantony,

    I know this is kind of old thread of I don't see that you've reached to a solution. I have created a UDF (User Defined Function) to address your issue. The expected results are not 100% matching to yours but since Arabic is my native language I believe I understand what you're trying to achieve & corrected it. Also, in the UDF, I am not taking only the first 5 letters but I am considering the first word (whether less than 5 or greater than 5 characters)

    To use the UDF, the file has to be a macro enabled & it could be used as follows

    =GetRoman(E2,$J$2:$K$38)

    I have attached the excel file & the UDF code is below

    Hope this helps & let me know how it goes

    Please Login or Register  to view this content.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    12-26-2018
    Location
    India
    MS-Off Ver
    2017
    Posts
    17

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)

    Thank You very much for your Timely response and Help.

    Attached excel is useful for me . If i have doubt regarding i will contact you again.

  9. #9
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,708

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)

    Glad I could help … Post back here & we'll be happy to assist

  10. #10
    Registered User
    Join Date
    05-22-2021
    Location
    bahrain
    MS-Off Ver
    2013
    Posts
    1

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)

    its giving only first name on the sell
    I want to convert full text on the cell
    could you help.

  11. #11
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,708

    Re: Change Arabic Characters to English - As per given transliteration table (PFA)

    Hi Majed & welcome to the forum

    Try below revised code ...
    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

+ 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. Urgent macro to change Alphabetic lettes from english to arabic
    By bmarroush in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2017, 01:53 PM
  2. Need to translate from Arabic language to English
    By faru_sheikh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2017, 03:37 AM
  3. Converting Arabic language to English
    By arshad.99.ali in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2016, 11:46 AM
  4. How to convert numbers from Arabic to English
    By voltaire101 in forum Excel General
    Replies: 5
    Last Post: 08-08-2015, 12:54 PM
  5. Transliteration to English
    By Azarudeen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2014, 04:50 AM
  6. 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
  7. Need to translate from Arabic language to English
    By gaminguy in forum Excel General
    Replies: 1
    Last Post: 01-10-2013, 05:22 AM

Tags for this Thread

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