Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the following issue with Excel 2013, which is still surprisingly lacking proper multilanguage support despite it being, you know, XXI century.

I have a text in Excel 2013 which is displayed as Êàïèòàëèçàöèÿ (gibberish) instead of Капитализация (proper Russian word).

Now, from Notepad++ I'm able to do the following simple step to convert gibberish to Russian:

  • Encoding - Character Sets - Cyrillic - Windows-1251

and the text converts from Êàïèòàëèçàöèÿ to Капитализация, which I can already copy&paste to any application in the usual way (the text encoding is ANSI per Notepad++, which seems to be the root of the problem since original source file was encoded with ANSI and not Unicode).

However, I can't seem to be able to do the same rather simple operation from within Excel 2013 (or, for that matter, the "uber powerful" text editor Word 2013).

That leads to my question: does anyone know a way to convert character set from within Excel 2013 itself?

As a side note I know there are some encoding options when you use text importing wizard (which, as another side note, doesn't really pop up when you just double-click on a CSV file, you have to actually for some weird reason perform this operation from within Excel itself) which might or might not work, but I already reformatted the imported file and am looking for a simple solution to be able to do character set change from within Excel itself - in the same simple manner I'm able to do that in any self-respecting text editor

Cheers,

Eugene

share|improve this question
    
take a look at this –  Raystafarian Feb 5 at 15:37
    
I don't need to translate anything - both the gibberish text and the proper text are in the same language (and I am perfectly capable of doing a translation within the same language :)). I need to change encoding - i.e. I need to tell the stupid Excel to display text using different character set. –  Evgeny Feb 5 at 23:07
    
Oh, my bad! Would this help? –  Raystafarian Feb 6 at 13:35
    
Not quite - I know how to convert a text file - though I'd just use my regular text editor instead of that stupid import function. I need to be able to convert an already formatted table text within Excel. Maybe it's just not possible :( –  Evgeny Feb 7 at 22:59
    
Ah, I got nothing then, sorry! –  Raystafarian Feb 8 at 12:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.