Returns the row number of a reference. ROW([reference]) The ROW function syntax has the following arguments: Reference Optional. The cell or range of cells for which you want the row number. If reference is omitted, it is assumed to be the reference of the cell in which the ROW function...
Sometime we have a requirement that we want to fetch data from last cell in a column. This task can be achieve by using INDEX Function (Return the value or reference of the cell at the intersection of particular row and column in a give range) COUNTA Function (Count the number of cell in a...
Finds one text value within another (case-sensitive) FIND and FINDB locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. Important: FIND is intended for use with languages...
Checks to see if two text values are identical Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document. EXACT(text1, text2) The EXACT function syntax...
Joins several text items into one text item Syntax: CONCATENATE(text1, , ...) For example: =CONCATENATE("Stream population for ", A2, " ", A3, " is ", A4, "/mile.") =CONCATENATE(B2, " ",C2) Argument name Description text1 (required) The first item to join. The item can be a text...
Removes all nonprintable characters from text Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is...
Returns the character specified by the code number Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters. Operating environment Character set Macintosh Macintosh character set Windows ANSI...