Regular Expressions 101

Explanation
Pro

Positive Lookbehind(?<=[=,])

Character Class[=,]

=the literal = (61₁₀ / 75₈ / 3D₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

\s*any whitespace character, repeated any number of times

Character Class[A-Za-z2]+

+matches at least one character from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

2the literal 2 (50₁₀ / 62₈ / 32₁₆)

Positive Lookahead(?=\()

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Negative Lookahead(?![^']*'!)

Negated Character Class[^']*

*matches any number of characters outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

'!the literal text '!

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

25 tokens

(?<=[=,])\s*[A-Za-z2]+(?=\()(?![^']*'!)

New

=VLOOKUP($A9,'Summary'!$A$10:$C$30,3,FALSE)
=IFERROR((C10/B10),"N/A")
=sum('New Chart =Data(Date)'!L70)
=IFERROR((C10/B10),Len(E30))

=VLOOKUP($A9,'Summary'!$A$10:$C$30,3,FALSE)
=IFERROR((C10/B10),"N/A")
=sum('New Chart =Data(Date)'!L70)
=IFERROR((C10/B10),Len(E30))