MicrosoftI believe you are correct that support for regular expressions would be a valuable addition. In the past I have used RegEx from VBA to pick out the elements of Danish Postal addresses but that involved VBA routines that were provided and, I think, the scripting runtime library. Having switched Excel from 32 bit to 64 bit I am no longer in a position to check the details. Hans Knudsen
Charles Williams does have some functions that use regular expressions in his Fast Excel add-ins along with timing routines and much else that I could recommend.
Why FastExcel V4 - Decision Models
An option that is now available in Excel that was never there in the past is to make up for any lack in terms of library functions by writing ones own code from scratch using the functionality that is available. For example I have written Fast Fourier Transformation algorithms that use TOCOL and WRAPROWS extensively to manipulate the complex roots of unity! In Python, I believe FFT is available in slightly different flavours within a couple of the libraries.
