• Decoding HTML Encoding of Foreign Language Text in a Spreadsheet

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Decoding HTML Encoding of Foreign Language Text in a Spreadsheet

    Author
    Topic
    WSTroyWells
    AskWoody Lounger
    June 19, 2012 at 9:37 am #483876

    As many do, our company translated our GUI and messages into many foreign languages. I am responsible for editing (the English) and managing translation of these. I recently asked for a dump of all the GUI labels/messages, which they provided in a CSV file. I could easly open this in Excel, and it worked great for most languages. However, for some languages, I just saw text like “عرض ا” which I am told is HTML encoding for the language (in this case Arabic). I know Excel can show Arabic script, but how do I convert this encoding to the actual script? Thanks in advance for your help!!

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSTroyWells
      AskWoody Lounger
      June 19, 2012 at 9:49 am #1337087

      Forgive me for reposting, but I tried in 2 different browsers (Firefox 13, and IE9), and could not get the “Edit Post” feature to work. This is what I was going to edit my post to say: As many do, our company translated our GUI and messages into many foreign languages. I am responsible for editing (the English) and managing translation of these. I recently asked for a dump of all the GUI labels/messages, which they provided in a CSV file. I could easly open this in Excel, and it worked great for most languages. However, for some languages, I just saw text like “#1593;#1585;#1590; #1575;” which I am told is HTML encoding for the language (in this case Arabic). I know Excel can show Arabic script, but how do I convert this encoding to the actual script? Thanks in advance for your help!! (p.s. the funny thing is the first time I pasted some code in above, it actually automatically made it into the script. I removed the “&” from the above in hopes of it staying similar to what I currently see.)

      Reply | Quote
      • WSMartinM
        AskWoody Lounger
        June 19, 2012 at 12:56 pm #1337121

        Do you have the Arabic language pack installed on the PC ?

        Also, what happens when you change the relevant cells to an Arabic font ?

        Reply | Quote
        • WSTroyWells
          AskWoody Lounger
          June 20, 2012 at 6:04 am #1337197

          As best I can tell, I do have the Arabic language pack, and this is not a font issue. I need to convert the HTML encoding to Arabic script, just as happened automatically when I tried my first post in this thread. I just need for that to happen within Excel.

          Reply | Quote
    Viewing 0 reply threads
    Reply To: Decoding HTML Encoding of Foreign Language Text in a Spreadsheet

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.