Text Functions

This group of function lets you work on the text existing in the cell or directly on a string or phrase.

LEFT(): extract leftmost characters from a string

            =LEFT(A1,5)

RIGHT(): extract rightmost characters from a a string

            =RIGHT(A1,5)

LEN(): returns the length of a string(including spaces)

            =len(A1)

MID(): returns specified number of characters from a string, starting from the specified position

            =mid(A1,7,5) 

            Returns 5 characters from string in cell A1 starting from 7^th character.

FIND(): returns the position of certain characters in a string

            =find(“Best”,A1)

PROPER(): capitalizes each word in the string

            =proper(A1)

REPT(): repeat certain text number of times

            =rept(a1,2)

TRIM(): removes unnecessary spaces from a particular string

            =trim(a1)

UPPER(): converts the text from to lower to upper

            =upper(a1)

SUBSTITUTE(): replaces existing text with new text

            =substitute(a1,”learn”,”understand”)

CONCATENATE(): joins the text in two or more cells

            =concatenate(a1,b1,c1)