String functions

String functions are functions that have a non-numerical result. A string is a sequence of characters not interpreted as a number, e.g. Jones, "25".

CELL(column,row)  returns the contents of the cell with coordinates column and row as text

CHAR(x)  character function

CODE(str)  character to code conversion

CONCAT(s1,s2)  joins two or more strings together

LEFT(str,n)  left portion of string

LEN(str)  length of string

LOWER(str)  converts str to lowercase

MID(str,pos,n)  returns middle n characters from str starting at position pos

PROPER(str)  sets the first character in each word to uppercase and the rest to lowercase

REPT(str,n)  repeats string str n time

REVERSE(str)  reverses a string

RIGHT(str,n)  right portion of a string

STR(x,n)  number to string conversion

UPPER(str)  converts str to uppercase

VALUE(str)  string to number conversion

See also

Privacy & cookies Contact Site map