『壹』 EXCEL單元格文字數字混合求和的公式
'自定義公式-按ALT+F11-插入模塊-粘貼代碼-將表格另存為啟用宏的格式
Function 求和(c As Range)
For Each a In c
If a <> "" Then
d = ""
For i = 1 To Len(a)
b = Mid(a, i, 1)
If b Like "[0-9]" Or b = "." Then d = d & b
If i < Len(a) Then
If Mid(a, i + 1, 1) Like "[0-9]" Or Mid(a, i + 1, 1) = "." Then
Else
d = ""
End If
End If
Next
求和 = 求和 * 1 + d * 1
End If
Next
End Function
