Hi all,
I'm facing an issue with Cyrillic signs in Excel. I've received a .xls file with combination of English and Russian language, but Russian is not displaying correctly, getting signs like: ÎÎÎ "Øåðâèí-Âèëüÿìñ Ïýéíòñ". Issue appear on Office 2010 and O365. I've got Polish, English and Russian keyboards installed.
Anyone faced the same problem and can advise how to resolve this?
I've tried to repair Office and save different file formats, but without effect.
attachment added
Last edited by tom9124; 05-11-2020 at 04:01 AM. Reason: adding attachment
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Welcome
thank You for advice, attachment added
tom9124, Installed keyboards don't reflect to text. Its very strange and i have no idea how it was done but code page of this text is 1252. For Russian charset it mast be 1251.
try to decode
https://2cyr.com/decode/?lang=en
Îðãàíèçàöèÿ: ÎÎÎ "ËÎÃÈÑÒÈÊ-ÇÀÏÀÄ" is Организация: ООО "ЛОГИСТИК-ЗАПАД"
You can use short code
Select range and start selectionTo1251.
Please Login or Register to view this content.
BMV, thank You, with that code, when I ran the macro it successfully changed signs to Cyrillic
So it's probably issue on that person PC who send me the file? Probably he saved it as a wrong format/coding or something?
I don't think so. Maybe source data for export was wrong.Originally Posted by tom9124
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks