Regular expression in Excel 2007

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Nichols Fryman
Best Answer
Best Answer
Answered By 0 points N/A #169352

Regular expression in Excel 2007

qa-featured

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._%+-][email protected][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)

Answered By 0 points N/A #169353

Regular expression in Excel 2007

qa-featured

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.

Login/Register to Answer

Related Questions