Text

Text functions (reference)

Function	Description
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