extractSheetName: Extracting the sheet name from a formula
Description
Extracts the sheet name from a formula of the form <SHEET_NAME>!<CELL_ADDRESS>
Usage
extractSheetName(formula)
Value
Returns the name of the sheet referenced in the formula. For quoted sheet names (required if names
contain e.g. whitespaces or exclamation marks (!)) in formulas the function returns the unquoted
name.
Arguments
formula
Formula string of the form <SHEET_NAME>!<CELL_ADDRESS>. Note that the validity
of the formula won't be checked.