EXCEL如何用公式提取单元格内空格后面的数字

Question

如题所述

Answer 1

假设数据写在a1单元格,则你要的两个公式分别为
=mid(a1,find("
",a1,find("
",a1,find("
",a1,find("
",a1)+1)+1)+1)+1,find("
",a1,find("
",a1,find("
",a1,find("
",a1,find("
",a1)+1)+1)+1)+1)-find("
",a1,find("
",a1,find("
",a1,find("
",a1)+1)+1)+1)-1)
=mid(a1,find("
",a1,find("
",a1,find("
",a1,find("
",a1,find("
",a1)+1)+1)+1)+1)+1,find("
",a1,find("
",a1,find("
",a1,find("
",a1,find("
",a1,find("
",a1)+1)+1)+1)+1)+1)-find("
",a1,find("
",a1,find("
",a1,find("
",a1,find("
",a1)+1)+1)+1)+1)-1)
最后的方法还是选中这一列---数据---分列---分隔符号---勾选"空格"---完成,这产就能将数据分开到一行的各个单元格中

Answer 2

添加一个模块
贴下面的代码
Public
Function
mysum(ByVal
str
As
String)
As
Integer
Dim
sum
As
Integer
Dim
b
As
Variant
a
=
Split(str,
"
")
b
=
UBound(a)
Dim
temA
As
Variant
sum
=
0
For
i
=
0
To
b
If
i
>
0
Then
temA
=
Split(a(i),
"+")
sum
=
sum
+
temA(0)
End
If
Next
mysum
=
sum
End
Function
在表格里要求哪一个就输入=mysum(坐标)