RegExLib.com - The first Regular Expression Library on the Web!

Please support RegExLib Sponsors

Sponsors

Regular Expression Details

Title Test Find 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
Source
Your Rating
Bad Good

Enter New Comment

Title

Name

Comment

Spammers suck - we apologize. Please enter the text shown below to enable your comment (not case sensitive - try as many times as you need to if the first ones are too hard):

Existing User Comments

Copyright © 2001-2024, RegexAdvice.com | ASP.NET Tutorials