|
![]() |
![]() |
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) |
||
|
||