| tmehta.com Home regexp/index.htm VB(A) functions Using functions Examples Patterns |
Excel supports a limited wildcard capability -- search Excel help for the keyword 'wildcard' (without the quotes). VBA supports a significantly better capability through its LIKE operator -- search Excel VBA help for the keyword 'wildcard' (without the quotes). However, now that VBScript supports regular expression, it is possible to dramatically enhance the search and replace capability of both VBA and Excel. The following are two wrapper functions that allow the use of regular expressions in Excel formulas! The new master calendar is replica watches uk one of the best tables in the past few years. Some people say that the product out of so many complicated table, what is replica watches sale the best it? Because the complex table destined only a few people can buy ah, but Jaeger-LeCoultre new master calendar allows more people to replica watches wear Jaeger-LeCoultre. In the past Jaeger LeCoultre look "formal", so many young people do not like it. The new master changed the original style, looks very young, 6,9,12 digital disk plus hollow pointer, with some "sports style." I replica watches online always have a trance to explore a feeling.
Adding the necessary code to an Excel workbook For more examples see my posts here (also search for regexp and author tusharm), as well as the Google archive of the Excel newsgroups. There is also a lot of material on the web. Search Google for more.
|