Excel - parse cell reference

0

Open in the Regex Tester

^
(?<colfix>\$?)# can have $ before the column letter
(?<col>[A-Z]{1,3})# column letter(s)
(?<rowfix>\$?)# can have $ before the row number
(?<row>[0-9]{1,7})# row number(s)
$

Split a cell reference $A$1 into its constituent parts

Alan Singfield
9/4/2013 9:39:38 AM

0 comments so far.

Log in to leave a comment.

<< back to Library