• Miscellaneous Functions
  • Miscellaneous Functions
  • BROWSTAT function
  • CELLCALC function
  • CELLCOL function
  • CELLLABEL function
  • CELLNO function
  • CELLROW function
  • CELLSTR function
  • CELLTABLE function
  • CUSTPROP function
  • CUSTPROPAT Function
  • CUSTPROPR function
  • CVDATA function
  • CVDATAC function
  • CVDATAL function
  • CVDATALNG function
  • CVDATAQRY function
  • CVDOCPOS function
  • CVFORM function
  • CVGROUP function
  • CVIDEA function
  • CVINFO function
  • CVMENUST function
  • DOCID function
  • DOCMODE function
  • EVAL function
  • GETHIDE function
  • INITIALS function
  • ISCONS function
  • ISINGROUP function
  • ISINGRP function
  • KLIEXIST function
  • KLIPROP function
  • KLLPROP function
  • LEVEL function
  • LOOKUP function
  • MKPATH function
  • RDYREVIEW function
  • REPENT function
  • SCRNX function
  • SCRNY function
  • WHOAMI function

CELLCOL Function

The CELLCOL function returns the table column number of the current cell as a string into the current cell.

Syntax

CELLCOL(<cell number>)

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

It is also possible to use the CELLCOL() function in skip and hide conditions on table columns. 

Example 1

Enter CELLCOL() in a table cell ABC.F1 returns 6, since F is the sixth letter of the alphabet.

Example 2

Enter CELLCOL(ABC.D135) returns 4, since D is the fourth letter of the alphabet.

This function provides an easy way to include table column information in such a way that it is re-referenced when columns are added or deleted or when a table is relabeled.

Related Topics

• Miscellaneous Functions