+ Reply to Thread
Results 1 to 9 of 9

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
    10

    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
    3,861

    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
    10

    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
    3,861

    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
    10

    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
    3,861

    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
    Registered User
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    20

    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
    10

    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
    Registered User
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    20

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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