can someone give me all string functions with their definition?
Answers
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