jiwan singh
New Member
in excell - custom value ""0"pcs" , how to get number & pcs in separate coloum
Option Explicit
Option Base 1
Function units(amount As Range)
Dim s As String
Dim v(10, 1) As String
Dim i As Long
For i = 1 To 10
s = amount.Item(i).Text
v(i, 1) = Right(s, 3)
Next i
units = v
End Function