My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

You are here: Home
Lost password?
sp_Search
Advanced Search
Advanced Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search

Please confirm you want to mark all posts read

Mark all topics read

sp_MobileMenu Actions
Avatar

New/Updated Topics

Select Forum

sp_TopicIcon
Regular Expression in Excel
Avatar
Adriano Giacomini
Posts: 1

Level 0
April 20, 2022 - 5:31 pm

1

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

Avatar
Velouria
London or thereabouts
Posts: 625

Level 4
April 20, 2022 - 11:48 pm

2

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.

Forum Timezone:
Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kim Knox, Tiffany Kang, Bhuwan Devkota
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)

Devices in use: Desktop (10), Phone (3)

Forum Stats:
Groups: 3
Forums: 24
Topics: 6221
Posts: 27285
Member Stats:
Guest Posters: 49
Members: 31909
Moderators: 3
Admins: 4