Alabama19, вариант функций в столбцах G F E или aaa1 bbb1 в столбцах I J
[vba]Код
Function aaa$(t$)
With CreateObject("VBScript.RegExp"): .Global = True: .Pattern = "\d+"
If .Execute(t).Count = 2 Then aaa = .Execute(t)(.Execute(t).Count - 1) Else aaa = ""
End With
End Function
[/vba]
[vba]Код
Function bbb$(t$)
With CreateObject("VBScript.RegExp"): .Global = True: .Pattern = "\d+"
If .Execute(t).Count = 1 Then bbb = .Execute(t)(.Execute(t).Count - 1) Else bbb = .Execute(t)(.Execute(t).Count - 2)
End With
End Function
[/vba]
[vba]Код
Function ccc$(t$)
With CreateObject("VBScript.RegExp"): .Pattern = "[А-ЯЁ][а-яё]+(?=, д\.)": ccc = .Execute(t)(0)
End With
End Function
[/vba]