Public Function УБРАТЬСЛУЧКИРИЛЛ(ТЕКСТ As String) As String
    Dim Rus As Variant
    Dim Eng As Variant
    Dim i As Double
    Dim j As Double
    Dim simb As String
    Dim FindLatin As Boolean
    Dim simbtrans As String
    Dim MergeText As String
 
    Eng = Array("a", "b", "c", "e", "k", "m", "n", "h", "o", "p", "t", "u", "y", "A", "B", "E", "K", "M", "O", "P", "C", "T", "H", "Y")
    Rus = Array("а", "в", "с", "е", "к", "м", "н", "н", "о", "р", "т", "и", "у", "А", "В", "Е", "К", "М", "О", "Р", "С", "Т", "Н", "У")
 
    For i = 1 To Len(ТЕКСТ)
        simb = Mid(ТЕКСТ, i, 1)
        FindLatin = False
        For j = 0 To 21
            If Rus(j) = simb Then
                simbtrans = Eng(j)
                FindLatin = True
                Exit For
            End If
        Next
        If FindLatin Then MergeText = MergeText & simbtrans Else MergeText = MergeText & simb
    Next
 
    УБРАТЬСЛУЧКИРИЛЛ = MergeText
End Function