例如，在B1中用途：

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))

看看有没有数字：

=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A1))>0

在IF中将两者结合：

=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))))>0,TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255)),"")

试试这个功能，例如= F编号（A1）或= F编号（“3ES INNOVATION INC 98-0485843”）。
我不确定所有的可能性都被列举出来了。正如Rawrplus所建议的那样，我假设在开始时至少有一个空格将数字与后来的数字分开。

Function FNumber(s As String) As String

With CreateObject("VBScript.RegExp")
    .Global = True
    .Pattern = ".\s(\d+-*\d+)"
    If .Test(s) Then FNumber = .Execute(s)(0).submatches(0)
End With

End Function

添加基础配方溶液。

{=TEXTJOIN(" - ";TRUE;IFERROR(INT(MID(A1; {1;2;3;4;5;6;7;8;9;10}; 1));""))}