TranslitRu function for Excel (Calc)

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 (Calc) 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 (LibreOffice Calc) .