Title |
Test
Find
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
|
Source |
|
Your Rating |
|
Title: cells are valid with preceding zeros!
Name: Thanassis Viennas
Date: 6/9/2005 6:10:51 PM
Comment:
Cell row ids are still valid while preceded with zero!(e.g. $A01)