Какие формулы необходимо использовать?

[yanasid1993]

При помощи каких формул добиться выделения наименования компаний и ИНН в отдельные ячейки.
Выделение ИНН из выписки.xlsx

[Aleksandr H.]

Здесь, скорее всего, макросом надо обрабатывать

[yanasid1993]

Aleksandr H., не подскажите каким?)

[Aleksandr H.]

yanasid1993, каким умеете


вот наброски 2 вариантов для обработки В13, пилите под себя

Option Explicit

Sub test1()
    Dim s As String
    Dim ar() As String
    Dim INN_pos As Integer
    Dim ln As Integer
    Dim space_pos As Integer
    Dim new_s As String
    ReDim ar(0)
    s = [b13] 
    s = Replace(s, " ,", ",")
    s = Replace(s, "  ", " ") & ","
    INN_pos = InStr(s, "ИНН: ")
    new_s = Mid(s, INN_pos, Len(s))
    space_pos = InStr(new_s, ",")
    
    Do While INN_pos > 0 And space_pos > 0 And s <> ""
        ln = UBound(ar)
        ReDim Preserve ar(ln + 1)
        
        ar(ln) = Trim(Left(s, INN_pos + space_pos - 2))
        
        s = Mid(s, INN_pos + space_pos, Len(s))
        If s <> "" Then
            INN_pos = InStr(s, "ИНН: ")
            new_s = Mid(s, INN_pos, Len(s))
            space_pos = InStr(new_s, ",")
        End If
        
    Loop
    Dim i As Integer
    For i = LBound(ar) To UBound(ar) - 1
        Debug.Print Split(ar(i), ",")(0), Replace(Split(ar(i), ",")(1), "ИНН: ", "")
    Next i
End Sub


Sub test2()
    Dim ar() As String
    Dim s As String
    Dim i As Integer
    s = Range("B13")
    ar = Split(s, ", ИНН: ")
    For i = 0 To UBound(ar) - 1
        If i = 0 Then
            Debug.Print "Firma :" & Split(ar(i), ", ")(0) & "; INN  :" & Split(ar(i + 1), ", ")(0)
        Else
            Debug.Print "Firma :" & Split(ar(i), ", ")(1) & "; INN  :" & Split(ar(i + 1), ", ")(0)
        End If
    Next i
End Sub