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've got about 10 thousand XLSX files that have content in Cyrillic alphabet. I need to transliterate the content of these files into Latin alphabet.

Is there any way to do it with Excel or do I have any other options?

share|improve this question
3  
I was so sure that "transliterate" wasn't a word! Learn something new every day. –  cmorse May 8 '13 at 13:49
    
Your question was off topic, we're not here to just provide you with source code etc. I've edited your question, if you want to roll it back, feel free. Either way, what have you tried to so far? –  Dave May 8 '13 at 13:59
    
At least you should provide a conversion Excel table where all cyrillic letters have there latin counterpart at the same row. Most of us have no clue if this table is complete and enough for you –  nixda Jul 7 '13 at 19:38

1 Answer 1

I do not know how it would stand performance-wise, but it can be done to a certain degree with user-defined VBA function, taking the Cyrillic string as argument, iterating through all the characters and replacing each of the Cyrillic letter with the translitterated equivalent, and returning the result.

A quick google search showed me https://gist.github.com/jenikm/3020221 which does the exact reverse of your task, I am sure you could find even more useful material.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.