question

dolevgeller-5839 avatar image
0 Votes"
dolevgeller-5839 asked OlafHelper-2800 answered

Regex pattern from cell

Is it possible to compare the content of one Excel cell with a regex pattern located in another cell?

office-vba-devoffice-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Yes, that's possible to pass a cell to a user defined function for RegEx match, see
https://stackoverflow.com/questions/22542834/how-to-use-regular-expressions-regex-in-microsoft-excel-both-in-cell-and-loops

=> Example 2

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.