CELLTABLE Function

The CELLTABLE function returns the table identifier of the current cell as a string into the current cell.

Syntax

CELLTABLE(<cell number>)

If a cell number is specified, it returns the table identifier of that cell, as a string. This reference must be a direct cell reference. If a cell is not identified, then the function returns the table identifier of the current cell.

Example 1

Enter CELLTABLE() in a cell in table DEF returns DEF.

Example 2

Enter CELLTABLE(ABC.d1) returns ABC.

This function provides an easy way to include table information in such a way that it is re-referenced when a table is relabeled.

Related Topics