106
General Software Discussion / Re: Excel - pattern matching in cells
« on: March 17, 2011, 06:22 AM »The lack of regular expression support in Office is quite frankly astounding.-Renegade (March 16, 2011, 07:10 PM)
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)
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)
Cheers, useful reading matter.
Target: Thanks for your input too also :)