MS-Excel (Text Functions)

EXCEL TEXT FUNCTION

LOWER
This function is used to convert selected text from upper to small letters.

EXAMPLE: =LOWER(A1)

UPPER
This function is used to converts selected text from small to capital letters. 

EXAMPLE: =UPPER(A1)

PROPER
This function is used to convert only first letter of every word in capital from.

EXAMPLE: =PROPER(A1)

CONCATENATE
This function is used to combine two or more text in one text line.

EXAMPLE: =CONCATENATE(A1,B1)

LEFT
This function returns a specified number of characters from the left side.

EXAMPLE: =LEFT(A1,4)

RIGHT
This function is used to returns a specified number of characters from the right side. 

EXAMPLE: =RIGHT(A1,4)

TRIM: Removes duplicate spaces, and spaces at the start and end of a text string.

LEN
This function returns the length of a selected text.

EXAMPLE: = LEN(A2) 

FIND
This function is used to returns the position of a given character in the selected text.
Note: The find function is case sensitive text function (Case sensitive means, its differ between "'a" and "A" )

EXAMPLE: = FIND("a",aA2)

EXACT
This function is used to tests two texts and return TRUE if texts match and return FALSE if texts do not match.

EXAMPLE: = EXACT(A2,B2)

CHAR: Returns the character that corresponds to a supplied numeric value.

CODE: Returns the numeric code for the first character of a supplied string.















HOME