Regular Expressions 101

Explanation

Pro

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

Character Class[a-zA-Z0-9 ]*

*matches any number of characters from the set below:

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

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

the literal (32₁₀ / 40₈ / 20₁₆)

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

\!the literal ! (33₁₀ / 41₈ / 21₁₆)

Character Class[a-zA-Z]{1,3}

{1,3}matches between 1 and 3 characters from the set below:

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

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

Character Class[0-9]{1,7}

{1,7}matches between 1 and 7 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Group 1(:[a-zA-Z]{1,3}[0-9]{1,7})?

?repeats the group contents below at most once:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Character Class[a-zA-Z]{1,3}

{1,3}matches between 1 and 3 characters from the set below:

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

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

Character Class[0-9]{1,7}

{1,7}matches between 1 and 7 characters from the set below:

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

'?[a-zA-Z0-9 ]*'?\![a-zA-Z]{1,3}[0-9]{1,7}(:[a-zA-Z]{1,3}[0-9]{1,7})?

New

='fdf dsfsd'!B6*'fdf dsfsd'!F13+F8/Sheet3!D9+SUMIF(Sheet3!G11:G16;">0";H8:H11)-IF(I7=K10;Sheet3!H14;'fdf dsfsd'!L19)

='fdf dsfsd'!B6*'fdf dsfsd'!F13+F8/Sheet3!D9+SUMIF(Sheet3!G11:G16;">0";H8:H11)-IF(I7=K10;Sheet3!H14;'fdf dsfsd'!L19)