Mass Cyrillic to Latin translation in Excel?
September 1, 2005 6:25 PM Subscribe
I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand.
posted by michaelkuznet to Computers & Internet (5 answers total)
The project is relatively straightforward:
I have an Excel file with 201+ pages of Russian names that I need transliterated, while leaving one or two other fields on the worksheet untouched. I have already converted the original Cyrillic font to unicode (thanks Firefox!!!), and know that it is possible to do the transliteration with a macro and Office 2003 for Windows
I'm using OS X.4 and Office 2004.
Even worse, I'm working in Excel, and am not particularly enthused about exporting over eight thousand names to Word. What are my options?
I can't get the windows version of the macro to work on my Mac, can I? Is there any way I can avoid doing a massive "find-and-replace" project by hand? I've found this
free macro online, but it's outdated.