+ Reply to Thread
Results 1 to 2 of 2

Trouble saving an Excel document as tab delimited file with Japanese Shift-JIS

  1. #1
    Registered User
    Join Date
    09-01-2019
    Location
    London
    MS-Off Ver
    2007, 2016
    Posts
    1

    Trouble saving an Excel document as tab delimited file with Japanese Shift-JIS

    rying to save an excel document containing Japanese characters as a tab delimited file with Japanese Shift-JIS

    I have done the following steps.

    Change the character encoding setting in the following steps before entering the product information in the template.
    Click on "File", "Save As", and select save location.
    Click on " Tools" in the lower right of the next screen, and click on "Web Options".
    In the "Encoding" tab, select "Japanese (Shift-JIS)" from the pull-down menu of "Save this document as:".
    4. Click on "OK".
    3) After complete changing the character encoding to "Japanese (Shift-JIS)", enter the product information in the template. 4) Save the file as "Text (Tab delimited)" format.

    However, when opening the saved text file I can see that it has not saved correctly due to hundreds of "???????????????????????"

    To recreate the problem, insert some Japanse text こんにちは、私の名前はジェニーです and try to save it according to the instructions above. The result should not be ???????????????????????

    Any help is appreciated.

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

    Arrow


    Just select the text Unicode format when using SaveAs feature

+ 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