string and numeric
would this macro help?
Sub cus()
Dim tekst as Integer
For Each cell In Selection
For i = 1 To Len(cell)
If IsNumeric(Mid(cell, i, 1)) Then
tekst = Len(cell) - i
Else:
Exit For
End If
Next i
cell.Offset(0, 1) = Left(cell, i - 1)
cell.Offset(0, 2) = Mid(cell, i, tekst)
Next cell
End Sub
|