Community Patterns

Community Library Entry

1

Regular Expression
Created·2015-03-12 20:53
Flavor·ECMAScript (JavaScript)

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

Description

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

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

Submitted by anonymous