Saturday, January 2, 2016

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


No comments:

Post a Comment