• Miscellaneous Functions
  • ASSIGNEDTO Function
  • B64TOGUID Function
  • BROWSTAT Function
  • CANSIGN Function
  • CELLCALC Function
  • CELLCOL Function
  • CELLLABEL Function
  • CELLNO Function
  • CELLROW Function
  • CELLSTR Function
  • CELLTABLE Function
  • COMPLETION Function
  • COMPLTBY 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
  • DOCENTSCP Function
  • DOCID Function
  • DOCLIBPATH Function
  • DOCMODE Function
  • EVAL Function
  • FIELD Function
  • GETHIDE Function
  • GUIDTOB64 Function
  • HASTAG Function
  • INITIALS Function
  • INPBLANK Function
  • INPBLANKRC Function
  • ISADMIN Function
  • ISCONS Function
  • ISINGROUP Function
  • ISLOCKED Function
  • ISPLHOLDER Function
  • ISSUECOUNT Function
  • ITEMPROP Function
  • KLIEXIST Function
  • KLIPROP Function
  • KLLPROP Function
  • LEVEL Function
  • LOOKUP Function
  • Miscellaneous Functions
  • MKPATH Function
  • NUMROLES Function
  • NUMSIGNED Function
  • RDYREVIEW Function
  • REPENT Function
  • ROLECOMPLT Function
  • ROLEINDEX Function
  • ROLELABEL Function
  • SCRNX Function
  • SCRNY Function
  • SIGNOFF Function
  • SIGNOFFCHK Function
  • SIGNOFFCVR Function
  • SIGNOFFDTE Function
  • SIGNOFFNME 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