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".

ACHAR(x)  ANSI character function

ACODE(str)  Character to ANSI code conversion

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

CHAR(x)  Unicode character function

CODE(str)  Character to Unicode code conversion

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

LEFT(str,n)  left portion of string

LEN(str)  length of string (code units count)

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

ULEN(str)  length of string (character count)

UPPER(str)  converts str to uppercase

VALUE(str)  string to number conversion

See also

This site uses cookies to store information on your computer. More info...