ExcelBanter - How to save Japanese characters in CSV format of Excel ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to save Japanese characters in CSV format of Excel ? (https://www.excelbanter.com/excel-discussion-misc-queries/47931-how-save-japanese-characters-csv-format-excel.html)

Murali Ayyagari

How to save Japanese characters in CSV format of Excel ?

Hi,
I would like to know, how to save the Doubly-Byte characters.For example,
Japanese in CSV of Excel.Here are the steps, I tried.
1. Open Excel
2. Copy pasted the Japanese charactesrs in a cell.It is displaying the
characters correctly.
3. Save as CSV(Comma seperated file)
It is saving as ??????.
Thanks in advance for the info.

All times are GMT +1. The time now is 02:37 AM.