TranslitUa function for Excel

TRANSLITUA() Description

The TRANSLITUA() function is designed to transliterate Ukrainian text into Latin.

Main Features Functions TRANSLITUA

Syntax:

=TRANSLITUA(Text)

Parameters:

• Text: Text in Ukrainian that needs to be transliterated into Latin.

Example Usage

The TRANSLITUA() function is easy to use. You just need to enter any text in Ukrainian, and Excel automatically converts it to Latin:

=TRANSLITUA(Text)

We will have the following result:

This example uses the following values:

• Text: A2 - Text for transliteration ("Бойко Іван Петрович") .

Transliteration Standard

Transliteration of text from Ukrainian into Latin is carried out in accordance with Resolution of the Cabinet of Ministers of Ukraine dated January 27, 2010 No. 55 "On the regulation of the transliteration of the Ukrainian alphabet into the Latin alphabet" (current).

Download extension

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

Or its free version YouLibreCalc .

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