Excel - parse cell reference

^
(?<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
09/04/2013 09:39:38

0 comments so far.

Excel - parse cell reference

<< back to Library