? sign problem in excel

Question

hi All , 

   in our company some users has "russian language" excel and some of them " english" .  in that case , they shared an excel file between them (from russian colleague to english one ). But  when you open that file as "excel format" everything seems fine, but we need to save that as "cvs format"  and when i save that and open again , russian  letters seems as "   ?????? ?????  ?????  ????? ? " signs. 

 and when i checked the language tab i see russian language is " not installed " and im not able to install that coz , when i click on it, its redirecting me to  windows buy page. But i already got licenced product and just want to add Russian language as third language ,it seems it will solve my problem. 

  does anyone has that problem ? or know how to download and add that language pack ? 

  thanks.

Answer 1

If you open the csv file in Notepad are these characters legible?

If not, then this is a Unicode Character Issue

To configure Excel to use unicode on your exported CSV reports:

Start Microsoft Excel

In Excel, click the Data tab, and in the Get External Data ribbon/panel, click From Text .

In the Import Text File dialog box, in the lower-right corner (to the right of the File name box), select Text Files (*.prn;*.txt;*.csv) as the file type, browse to the location where you exported/downloaded the CSV file, and then click Open (or Import).

In the Text Import Wizard - Step 1 of 3 dialog box, select Delimited, and from the File origin drop-down list, select 65001: Unicode (UTF-8) (or the appropriate language character identifier for your particular environment).

In the Preview box, make sure that your unicode text displays properly, and then click Next.

In the Text Import Wizard - Step 2 of 3 dialog box, in the Delimiters section, make sure that only Comma is checked, and then click Finish.

In the Import Data dialog box, select New worksheet (or Existing worksheet if you have one), and then click OK

Answer 2

Try adding Russian as outlined below -

https://support.office.com/en-us/article/Add-a-...