Forum Discussion
MicrosoftNew Regular expression (Regex) functions in Excel
But used pattern is not hided. It is within the cell, or text within REGEX..., or returned by some function. In any case it's available.
The actual purpose of such a function is to find the Regular Expression which need to used to get the format like that.
E.g., RegexExtract(B2, "[A-z]+ [A-z]+",1) is required to find the name Sonia Rees from text given in Cell B2
What RegexPattern() intends to do is that If I Type Sonia Rees in Cell B1 and then use the formula RegexPattern(B1) in Cell C1, it gives me the Result "[A-z]+ [A-z]+"
Here any non-technical person can make use of the Other Regex functions efficiently because we don't even have to search anywhere else for the pattern expressions.
Just Like =CODE("x") gives us the value 120 and we can use =Char(120) to generate x
Regards
Kanwaljit
I see. Looks like RegEx generator. Not simple task.
