4 ms·
Random point but Excel sure could use a CONTAINS function for substring matches. I was looking for something like this yesterday and the solutions I found were
by newman314 10y ago
Random point but Excel sure could use a CONTAINS function for substring matches.
I was looking for something like this yesterday and the solutions I found were quite ugly.
Ended up having to use DSUM/DCOUNT instead which is still inelegant when one has to to multiple lookups with slightly varying parameters.
- bereasonable 10y agoWe're planning on adding support for regex. The current state of the work is shown on our User Voice site. https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9022339-built-in-regex-regular-expressions-functions-to https://excel.uservoice.com/forums/304921-excel-for-windows-...