Displaying page
of
pages;
Items to
|
Title |
Test
Details
Simple Excel Cell Address Parse
|
|
Expression |
^\$?([A-Za-z]{0,2})\$?([0-9]{0,5}):?\$?([A-Za-z]{0,2})\$?([0-9]{0,5})$
|
|
Description |
Since MS Excel will be giving you the cell range addresses, this simple regex provides nice match captures. It may not validate the only possibles that Excel takes, but it is "good enough" for a majority of circumstances.
|
|
Matches |
$A:$A|$5:$5|$H$19|H19|g21:n36|$G$31:$N$36
|
|
Non-Matches |
$A$A
|
|
Author |
Rating:
Not yet rated.
Jason Cable
|
Displaying page
of
pages;
Items to
