循环判断字符是否是数字就好了,按照你上面的字符串做示例nr = "张三13812345678"For i = 1 To Len(nr) If IsNumeric(CLng(mid(nr, i, 1))) = True Then Exit For : End If : Nextnr1 = Mid(nr, i, Len(nr)):nr2 = Mid(nr, 1, i-1)TracePrint nr1&"/"&nr2