Regex pattern from cell

dolev geller 1 Reputation point
2021-06-29T11:44:50.143+00:00

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

Microsoft 365 and Office Development Other
Developer technologies Visual Basic for Applications
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2021-06-29T11:59:30.373+00:00

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.