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
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)
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.
