Regular Expressions 101

Character Class[A-Z$]+

+matches at least one character from the set below:

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

$the literal $ (36₁₀ / 44₈ / 24₁₆)

\d+a digit, repeated at least once

Non-Capturing Group(?::[A-Z$]\d+)?

?repeats the group contents below at most once:

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

Character Class[A-Z$]

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

$the literal $ (36₁₀ / 44₈ / 24₁₆)

\d+a digit, repeated at least once

Global pattern flags

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

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

[A-Z$]+\d+(?::[A-Z$]\d+)?

New

=A$13:B4+$BC$12+$DE2+F2:G2