Separating Non-Numeric Characters And Numbers In Excel
We used "Regular Expression Language (Regex)" for this tutorial.Cells in column B were used as sample.
Data are parsed with the button into Column C (as numeric) and Column D (as alphabetic)..
This pattern code was used "to separate numbers" :
With RegEx
.Global = True
.Pattern = "\d+"
End With
To seperate non-numeric characters (letter etc.) :
With RegEx2
.Global = True
.Pattern = "[^0-9,]"
End With
