Regular Expressions 101

Community Patterns

Cell Reference Matcher

0

Regular Expression
PCRE (PHP <7.3)

/
(('[a-zA-Z0-9, &-]+'!)|([a-zA-Z, &-]+!))?(((\$?[a-zA-Z]{1,3}\$?[0-9]+#?)(:\$?[a-zA-Z]{1,3}\$?[0-9]+)?)|(\$?[a-zA-Z]{1,3}:\$?[a-zA-Z]{1,3})|(\$?[0-9]+:\$?[0-9]+))
/
gm

Description

no description available

Submitted by anonymous - 4 years ago