Parsing a text string

ToriMac 

Press Alt+F11 to activate the Visual Basic Editor.

If you don't see the code immediately, expand Modules in the pane on the left and double-click Module1.

The function currently looks like this:

Function ParseIPA(Word As String)
    Dim i As Long
    Dim j As Long
    Dim c As Range
    Dim n As Long
    Dim r(1 To 20) As String
    i = 1
    Do
        For j = 3 To 1 Step -1
            Set c = Worksheets("SymbolsToCSNotationLookup").Range("A2:A53").Find(What:=Mid(Word, i, j), LookAt:=xlWhole)
            If Not c Is Nothing Then
                n = n + 1
                r(n) = c.Value
                Exit For
            End If
        Next j
        i = i + Len(r(n))
    Loop Until i > Len(Word)
    ParseIPA = r
End Function

The line

    Dim r(1 To 20) As String

specifies that the function returns at most 20 characters. If you need more, simply replace 20 with a larger number.

On the spreadsheet, you will have to select the corresponding number of cells in a row, enter the formula and press Ctrl+Shift+Enter if you don't have Excel in Microsoft 365.