Hi there!
I love regular expressions (Examples of regular expressions (regular-expressions.info)) and use them for any string manipulation.
Years ago I discovered a great free addin (Morefunc, see attachment, this is the last version I found in 2007), it has a lot of functions for excel even though I actually only use "regex*" functions
Unfortunately I can't find the 64bit version of this addin. I guess it was never developed or compiled.
With the recent releases of office 365 a lot of new features have been introduced ("LET" and "LAMBDA" are my favorites <3 ) but I still don't see anything related to regex.
Do you have any suggestion? the transition to 64bit is more and more imminent
PS: this is my first post, happy to join to you
Adriano
You can write UDFs to use regex. Depending on the nature of the regex, a fair bit can be done with FILTERXML, or new functions like textsplit, textbefore, textafter.
