TranslitRu function for Excel

TRANSLITRU() Description

The TRANSLITRU() function is designed to transliterate Russian text into Latin.

Main Features Functions TRANSLITRU

Syntax:

=TRANSLITRU(Text; [Standard])

Parameters:

• Text: Text in Russian that needs to be transliterated into Latin.
• [Standard]: Optional. Transliteration standards :
  0. General standard. Selected by default.
  1. International standard ICAO (Doc 9303) . Used for transliteration of foreign passports and driver's licenses.
  2. State standard ГОСТ 7.79-2000 (ISO 9) .
  3. International standard BGN/PCGN (1944) .
  4. International standard BGN/PCGN (1944) with word ending replacement "ий" and "ый" on "y" .

Example Usage

The TRANSLITRU() function is easy to use. You just need to enter any text in Russian and select the transliteration standard, and Excel automatically converts it to Latin:

=TRANSLITRU(Text; Standard)

We will have the following result:

This example uses the following values:

• Text: A2 - Text for transliteration ("Паниковский Михаил Самуэлевич") .
• Standard: B2 - General standard of transliteration (0) .

Download extension

You can use the function TRANSLITRU() by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .