vert line

CLR or CLEAR

Clears the specified cell or range.

CLR(cell) or CLR(range)

cell any cell reference

range any worksheet range

This function clears all the information from the cell or range specified, including both data and formatting information.

Returns: cell or range

clear(a1)

clear(a1:b7)

clear(myrange)

CLRDATA or CLEARDATA

Clears any data from the specified cell or range.

CLRDATA(cell) or CLRDATA(range)

cell any cell reference

range any worksheet range

This function clears the data (but not the formatting information) from cell or range.

Returns: cell or range

clrdata(a1)

clrdata(a1:b7)

clrdata(myrange)

CLRFMT, CLEARFMT or CLEARFORMAT

Clears any formatting information from the specified cell or range.

CLRFMT(cell) or CLRFMT(range)

cell any cell reference

range any worksheet range

This function clears formatting information (but not the data) from cell or range.

Returns: cell or range

clrfmt(a1)

clrfmt(a1:b7)

clrfmt(myrange)

CLRNUM or CLEARNUM

Clears numerical data from the specified cell or range.

CLRNUM(cell) or CLRNUM(range)

cell any cell reference

range any worksheet range

This function clears the numerical input from cell or range, but not strings, formulas, or formatting information.

Returns: cell or range

clrnum(a1)

clrnum(a1:b7)

clrnum(myrange)

CLRSTR or CLEARSTR

Clears string data from the specified cell or range.

CLRSTR(cell) or CLRSTR(range)

cell any cell reference

range any worksheet range

This function clears any string data from cell or range, but not numerical input, formulas, or formatting information. It returns cell or range.

Returns: cell or range

clrstr(a1)

clrstr(a1:b7)

clrstr(myrange)

COPY

Copies a cell or range from one location to another.

COPY(source,dest)

source any cell reference or worksheet range

dest any cell reference or worksheet range

The COPY function copies the information from source into dest. If a cell reference is given for dest, it will be used as the upper left hand corner of the destination range. Any information in the destination range will be overwritten.

Returns: dest

copy(a1:b7,d12)

copy(myrange,d12:e14)

COPYFMT or COPYFORMAT

Copies formatting information of a cell or range from one location to another.

COPYFMT(source,dest)

source any cell reference or worksheet range

dest any cell reference or worksheet range

This function copies formatting information only (but not the values) from source into dest. If a cell reference is given for dest, it will be used as the upper left hand corner of the destination range. Any information in the destination range will be overwritten.

Returns: dest

copyfmt(a1:b7,d12)

copyfmt(myrange,d12:e14)

COPYVAL

Copies the values of a cell or range from one location to another.

COPYVAL(source,dest)

source any cell reference or worksheet range

dest any cell reference or worksheet range

This function copies the values only (but not the formatting) from source into dest. If a cell reference is given for dest, it will be used as the upper left hand corner of the destination range. Any information in the destination range will be overwritten.

Returns: dest

copyval(a1:b7,d12)

copyval(myrange,d12:e14)

FORMTOVAL or FORMULASTOVAL

Converts formulas to their current values.

FORMTOVAL(cell) or FORMTOVAL(range)

cell any cell reference

range any worksheet range

This function converts any formulas in the cell or range to their current values. Any cell references within the formulas will be converted to the values of the cells referenced, and the values of the formulas will be calculated.

Returns: cell or range

formtoval(a1)

formtoval(a1:b7)

formtoval(myrange)

LOWER

Converts strings in a cell or range to lower case.

LOWER(cell) or LOWER(range)

cell any cell reference

range any worksheet range

Converts the strings in the cell or range to lower case, regardless of their original case.

Returns: cell or range

lower(a1)

lower(a1:b7)

lower(myrange)

MOVE

Moves the information in a cell or range.

MOVE(source,dest)

source any cell reference or worksheet range

dest any cell reference or worksheet range

Moves the information from source into dest. If a cell reference is given for dest, it will be used as the upper left hand corner of the destination range. Any information in the destination range will be overwritten.

Returns: dest

move(a1:b7,d12)

move(myrange,d12:e14)

NUMTOSTR

Converts numbers in the specified cell or range to strings.

NUMTOSTR(cell) or NUMTOSTR(range)

cell any cell reference

range any worksheet range

This function any converts numerical values in cell or range to strings.

Returns: cell or range

lower(a1)

lower(a1:b7)

lower(myrange)

PROPER

Converts the strings in the specified cell or range to Proper Case.

PROPER(cell) or PROPER(range)

cell any cell reference

range any worksheet range

This function converts the strings in the cell or range to Proper Case, regardless of their original case. The first letter of each word is capitalized, and all remaining letters are converted to lower case.

Returns: cell or range

proper(a1)

proper(a1:b7)

proper(myrange)

SELECT

Selects a cell or range in the worksheet.

SELECT(cell) or SELECT(range[, selectedcell])

cell any cell reference

range any worksheet range

selectedcell an [optional] cell reference within

This function highlights cell or range. If selectedcell is specified and is within range, that cell is selected; otherwise, the upper left cell is selected.

Returns: cell or range

select(b17)

select(a10:g19,b13)

SELECTALL

Selects all cells in the sheet.

SELECTALL([selectedcell])

selectedcell an [optional] cell reference

This function highlights the entire sheet. If selectedcell is specified, that cell is selected; otherwise, the upper left cell (A1) is selected.

Returns: the range reference of the selected area

selectall()

selectall(g29)

STRTONUM

Converts strings in the specified cell or range to numbers.

STRTONUM(cell) or STRTONUM(range)

cell any cell reference

range any worksheet range

This function converts any strings in cell or range to their numerical equivalent.

Returns: cell or range

strtonum(a1)

strtonum(a1:b7)

strtonum(myrange)

TRANSPOSE

Transposes the data from a range, switching rows and columns.

TRANSPOSE(source,dest)

source any cell reference or worksheet range

dest any cell reference or worksheet range

This function transposes the information from source into dest, such that rows and columns are transposed. If a cell reference is given for dest, it will be used as the upper left hand corner of the destination range. Any information in the destination range will be overwritten.

Returns: dest

transpose(a1:b7,d12)

transpose(myrange,d12:e14)

UPPER

Converts strings in the specified cell or range to UPPER CASE.

UPPER(cell) or UPPER(range)

cell any cell reference

range any worksheet range

This function converts any strings in the cell or range to UPPER CASE, regardless of their original case.

Returns: cell or range

upper(a1)

upper(a1:b7)

upper(myrange)

 

Also go to:

Index help

Contents help