Regular Expressions 101

Community Patterns

Excel extract cell col and row index

1

Regular Expression
PCRE (PHP <7.3)

/
^(?<column>[A-Z]+)(?<row>[1-9]\d*)$
/

Description

extract col index and row index from an Excel coordinate cell

Submitted by Julien Tissier - 8 years ago