# Text | 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

|