Home > Excel Tutorial > Excel Regular Expression Examples – 1

Excel Regular Expression Examples – 1

Separating Text And Numbers – Regular Expression Extract

We used “Regular Expression Language (Regex)” for this tutorial.Cells in column B were used as sample.

This regex 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

regex extract

Visit Here To Download Template

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: