Extracts the sheet name from a formula of the form <SHEET_NAME>!<CELL_ADDRESS>
Formula string of the form <SHEET_NAME>!<CELL_ADDRESS>. Note that the validity of the formula won't be checked.
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.
Mirai Solutions GmbH https://mirai-solutions.ch
1 2 3 4
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.