Text
Text functions (reference)
LOWER
Converts all characters in a supplied text string to lower case
example: =LOWER("Hello")
result: hello
UPPER
Converts all characters in a supplied text string to upper case
example: =UPPER("Hello")
result: HELLO
TRIM
Removes duplicate spaces, and spaces at the start and end of a text string
example: =UPPER(" Hello World !")
result: Hello World !
LEFT
Returns a specified number of characters from the start of a supplied text string. example: =LEFT("Hello",2)
result: He
MID
Returns a specified number of characters from the middle of a supplied text string syntax:=MID(text,start_index,no_chars)
example =MID("Ajay Kumar K",6,5)
result: Kumar
RIGHT
Returns a specified number of characters from the end of a supplied text string
example: =RIGHT("Hello",2)
result: lo
FIND
Returns the position of a supplied character or text string from within a supplied text string (case-sensitive).
syntax:=FIND(text,find_text,startPoistion)
example: =FIND("AJAY","A",1)
result: 1
LEN
Returns the length of a supplied text string
example: =LEN("Hello")
result: 5
Last updated