I think I have it..the only thing I cannot figure out is the "literal" dollar sign that would be part of the number. Below is the revised code. Is there a way to set it up to ignore dollar signs?
Sub SplitTextNum()
Dim r As Range, rC As Range
Dim v As Variant
Set r = ActiveCell
With CreateObject("VBScript.RegExp")
.Pattern = "(\d+([/.-]\d+\d+([/.-]\d+))?|\D+)"
.Global = True
For Each rC In r
v = Split(Mid(.Replace(rC.Value, "|$1"), 2), "|")
rC.Resize(, UBound(v) + 1).Value = v
Next rC
End With
End Sub
Bookmarks