Jun 03 2022 12:08 PM
I'm trying to use a custom RegEx function I found in my Data Model table, however, the cell only displays the formula I entered instead of the return value. I've tested the function outside of the table and it works exactly as I would expect. I selected the referenced cells rather than typing it out and this is what Excel changed it to: =RegExpMatch('RegEx Patterns'!B2,[@[Text 1]])
Text 1 is the name of the referenced column, I tried changing it back to C4 and that didn't work. I also tried adding the table name from the data model after the @ but that didn't do anything either. Text 1 is highlighted like it's a live reference but B2 isn't for some reason. Any ideas why the function wouldn't work in this context? Oh, and the function pops up when I start typing in the workbook, but not when I try it in the Data Model. Not sure if that's related.
Jun 03 2022 12:35 PM
SolutionJun 03 2022 12:35 PM
Solution