The following RegEx Pattern ID's Constants in Excel Formulas. In addition, the Pattern appends the Operator (which actually preceeds the Constants in the Excel Formula) to the Constants and I would like the Operator to disappear as prepended of appended.
Possible candidates for deletion are: >>>> [^-+*/^<>=]+ [-+*/^<>]
Dim Pattern As String = "(-?(('[\s\S]*?'!\w+)|(\([\s\S]*?\))|([^-+*/^<>=]+)))([-+*/^<>][<>=]?|$)"
That said, in case I need a revised prepending-pattern in the future, I would like two solutions (Match Patterns) :
1) No Operators appended or Prepended at all (Constants only)
2) Operators (which precede the Constants in Excel Formulas) Prepended to the Constants
View Complete Post