Separating Text And Numbers

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