next up previous contents index
Next: CONCATENATE, STRCAT Up: A. Function Reference Previous: COL, COLUMN   Contents   Index


COLS, COLUMNS

Syntax: COLS(R)
  COLUMNS(R)

R = a range

COLS returns the number of columns in the specified range.

COLUMNS is a synonym for COLS.

Examples:

COLS(A3..J17) = 10

COLUMNS(A7..H17) = 8

Excel function: COLUMNS


next up previous contents index
Next: CONCATENATE, STRCAT Up: A. Function Reference Previous: COL, COLUMN   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003