Function TranslitRu

TRANSLITRU() Description

The TRANSLITRU() function is designed for transliterating text from Russian into Latin.

Main Characteristics of the Function 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 transliterating foreign passports and driving licenses.
  2. State standard ГОСТ 7.79-2000 (ISO 9).
  3. International standard BGN/PCGN (1944).
  4. International standard BGN/PCGN (1944) with replacement of word endings "ий" and "ый" to "y".

Example of Use

The TRANSLITRU() function is simple to use. You just need to enter any text in Russian and select a transliteration standard, and Excel (Calc) will automatically convert it to Latin:

=TRANSLITRU(Text; Standard)

We will have the following result:

In this example, the following values are used:

• Text: A2 - Text for transliteration ("Паниковский Михаил Самуэлевич").
• Standard: B2 - General transliteration standard (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 will be opened in Excel (LibreOffice Calc).