TL; DNR : do excel formulas really provide regular expressions to match a pattern?
My task is to extract numerical values from strings (containing addresses in this particular case). Solving the VBA regex problem would be pretty simple, but unfortunately I would rather not use it.
Are excel formulas available to match patterns with functions with similar expressiveness? SEARCH seems rather limited, and in order to work, it needs to use patterns that, since the text is sent to the user, I cannot rely on.
regex excel excel-formula
mercuk
source share