Function Stk(code As String) As Variant
Dim x, z As Variant
Dim m As Integer
x = Split(code)
For m = LBound(x) To UBound(x)
If x(m) Like "*%*" Then
z = Split(x(m), "%")
Stk = z(0)
ElseIf x(m) Like "*bp*" Then
z = Split(x(m), "bp")
Stk = z(0) / 100
End If
Next
End Function
Sub teststr()
Dim code As String
code = " 5x15 15bp cms2 160/"
MsgBox " test " & Stk(code)
End Sub