×

Loading...

Hope it's helpful

sNumber = Split(sVariable, "-")

If UBound(sNumber) > 1 Then
sVariable = sNumber(0) & "-"
For i = 1 To UBound(sNumber)
sVariable = sVariable & sNumber(i)
Next
End If
Report

Replies, comments and Discussions: