Regular Expressions 101

Community Library

Community Library Entry

1

Regular ExpressionOpen Workspace

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

Description
Created·2015-03-12 20:53
Type·Substitution
Flavor·JavaScript

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

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

Submitted by Anonymous
Open Workspace