Regular Expressions 101

Community Patterns

Google Sheets Reference Formula

1

Regular Expression
ECMAScript (JavaScript)

/
=?('?([\w ]+)?'?!)?\$?([A-Z]+)\$?([0-9]+)(:\$?([A-Z]+)\$?([0-9]+))?
/
gi

Description

Matches and extracts the relevant parts of reference formulas from Google Sheets.

For instance: ='Test Sheet'!H$5

Submitted by anonymous - 9 years ago