Displaying page
of
pages;
Items to
Title |
Test
Details
Pattern Title
|
Expression |
(^[A-Z]{1,2}[0-9]{1,}:{1}[A-Z]{1,2}[0-9]{1,}$)|(^\$(([A-Z])|([a-z])){1,2}([0-9]){1,}:{1}\$(([A-Z])|([a-z])){1,2}([0-9]){1,}$)|(^\$(([A-Z])|([a-z])){1,2}(\$){1}([0-9]){1,}:{1}\$(([A-Z])|([a-z])){1,2}(\$){1}([0-9]){1,}$)
|
Description |
Matching any valid MS Excel range
|
Matches |
A1:BB10 | $A1:$BB10 | $A$1:$BB$10
|
Non-Matches |
$A1:BB10
|
Author |
Rating:
Thanassis Viennas
|
Title |
Test
Details
Pattern Title
|
Expression |
(^[A-Z]{1,2}[0-9]{1,}:{1}[A-Z]{1,2}[0-9]{1,}$)|(^\$(([A-Z])|([a-z])){1,2}([0-9]){1,}:{1}\$(([A-Z])|([a-z])){1,2}([0-9]){1,}$)|(^\$(([A-Z])|([a-z])){1,2}(\$){1}([0-9]){1,}:{1}\$(([A-Z])|([a-z])){1,2}(\$){1}([0-9]){1,}$)
|
Description |
A regular expression for any valid MS Excel range
|
Matches |
A1:BB10 | $A1:$BB10 | $A$1:$BB$10
|
Non-Matches |
$A1:BB10
|
Author |
Rating:
Not yet rated.
Thanassis Viennas
|
Displaying page
of
pages;
Items to