Log In
Register
Home
New Member
April 20, 2022
Offline
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
Trusted Members
Moderators
November 1, 2018
Offline
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.
1 Guest(s)
