方法很多,先给你两种:
1、数组公式法:比如您的数据在A3单元格,在B3单元格中输入:=MID(A3,MATCH(,0/MID(A3,ROW($1:$49),1),),COUNT(-MID(A3,ROW($1:$49),1))),然后同时按下shift+ctrl+enter
2、VBA法:
在模块中自定义个函数:
Function MyGet(Srg As String, Optional n As Integer = False, Optional start_num As Integer = 1)
Dim i As Integer
Dim s, MyString As String
Dim Bol As Boolean
For i = start_num To Len(Srg)
s = Mid(Srg, i, 1)
If n = 1 Then
Bol = Asc(s) < 0
ElseIf n = 2 Then
Bol = s Like "[a-z,A-Z]"
ElseIf n = 0 Then
Bol = s Like "#"
End If
If Bol Then MyString = MyString & s
Next
MyGet = IIf(n = 1 Or n = 2, MyString, Val(MyString))
End Function
然后在表格中调用:
比如数据在A1,在B2中输入:=Myget(A1),然后回车