Regular expression in Excel 2007

Asked By jolie angeliname 0 points N/A Posted on - 10/20/2013

Hi Techyv Friends,

I need tutorial on using of regular expression in Excel 2007. Please do the needful, If there is any other way to get examples on using regular expressions in MS Excel 2007.

Please guide me,

Jolie Angeliname

• Status: Open
• Question Views: 1390
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Nichols Fryman

Go To Solution

Best Answer

Best Answer

Answered By Nichols Fryman 15 points N/A #169352

Regular expression in Excel 2007

Hi Jolie,
Here is the link for tutorial on using Regular Expression in Excel 2007.

The examples of regular expression are:
Example 1) Find invalid address from a column of email address. The formula will return FALSE for all invalid email addresses.
=RegexpIsMatch("youremailaddress";"^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Za-z]{2,6}$"
Example 2) Find a particular part in a text. Suppose you have a column with text "Sports(id:5)", where you want the value "5" into a new column.
=RegexpFind(A1;"(id:(d+))";1)

About Nichols Fryman

Questions
0

Answers
701

Best Answers
99

• Vote Up 0 Vote Down

• Posted on - 10/20/2013
• Question Category: MS Excel

Answered By Anica Macri 0 points N/A #169353

Regular expression in Excel 2007

Hi Jolie

This is the tutorial for regular expressions that you asked for. Using Regular Expressions.

And you could try this one also. Simple Regular Expressions Tutorial for Excel VBA. A powerful tool that can help you data cleanse and data mine.

About Anica Macri

Questions
0

Answers
101

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/26/2013
• Question Category: MS Excel