Main Area and Open Discussion > General Software Discussion

Excel - pattern matching in cells

<< < (2/2)

Renegade:
Basic tutorial on using regular expressions in Excel VBA: http://www.tmehta.com/regexp/index.htm
Regular Expression guide (many languages): http://www.regular-expressions.info/
List of articles showing some other ways of using Regex in Excel VBA: http://excelicious.wordpress.com/category/regular-expressions/

-kfitting (March 17, 2011, 05:46 AM)
--- End quote ---

That's some good stuff there!

I'm still hoping that they add in pure .NET at some point as I don't really like VBA.

Ampa:
The lack of regular expression support in Office is quite frankly astounding.
-Renegade (March 16, 2011, 07:10 PM)
--- End quote ---

Glad you agree! I realise that they are available via VB, but why on earth can't I have easy GUI access in dialogues such as Conditional Formatting and Data Validation?!

If you don't mind using UDFs (User Defined Excel Functions), regular expression matching is also possible:
-moonwatcher (March 17, 2011, 02:04 AM)
--- End quote ---

This looks great! Thanks for such a clear complete and yet concise reply!  :up:

Basic tutorial on using regular expressions…
-kfitting (March 17, 2011, 05:46 AM)
--- End quote ---

Cheers, useful reading matter.

Target: Thanks for your input too also :)

kfitting:
Actually, what I like less than having "no Regular Expression support" in office, is having "partial support only in Word."  Look at the Word Find help and you'll see some regex-like stuff.  To me it just completely confuses the issue (personal opinion of course). 

At least with VB you can get it back, but yes, it would certainly be nice to have it built in (unless you dont dont trust the probability of MS' implementation being helpful of course!). 

bob99:
In addition to the help & great site links above the forums at Mr. Excel might be of help. http://www.mrexcel.com/forum/index.php
I looked and Mr. Excel was briefly mentioned in the forums back in 09.  The forum members are quite active like they are here and helped me out recently with something I was trying to do.

On the main page http://www.mrexcel.com/ he also has tutorial videos, a blog and other helpful information.  Some free some some not.

Not affiliated with them in any way.

Navigation

[0] Message Index

[*] Previous page