N/APosted 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,
Regular expression in Excel 2007
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.
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.