Tutorial on Excel Text Functions

In this tutorial we will learn the list of Excel Text functions and how to effectively utilize the Text functions for the purpose of text operations that we require

 

TRIM Function in Excel: TRIM Function in Excel removes all Extra space from a supplied text string. TRIM function keeps only one space between the words and removes all the extra spaces.

 

LOWER Function in Excel: LOWER Function in Excel converts all the supplied character strings to lower case.

 

UPPER Function in Excel: UPPER Function in Excel converts all the supplied character strings to Upper case.

 

PROPER Function in Excel: PROPER Function in Excel converts all the supplied character strings to proper case i.e. starting letter of every word in a sentence will be in upper case and rest all other letter in a word will be in lower case.

 

DOLLAR Function in Excel: DOLLAR Function in Excel rounds the supplied number to a specified number of decimal places and converts them into currency format by adding dollar symbol in front.

 

FIXED Function in Excel: FIXED Function in Excel rounds the supplied number to a specified number of decimal places and converts them into text format.

 

TEXT Function in Excel: TEXT Function in Excel converts numeric value into text, in a user specified format

 

VALUE Function in Excel: VALUE Function in Excel converts Text into numeric value or number.

 

CHAR FUNCTION IN EXCEL: CHAR Function in Excel returns the Character for the corresponding ASCII Value. CHAR Function takes up the number (ranging from 1 to 255) as an input and matches with the ASCII value and returns the corresponding character.

 

CODE Function in Excel: CODE function in Excel gets the character as an input and returns the corresponding ASCII Value

 

UNICHAR Function in excel: The UNICHAR Function in Excel takes up the number as an input and returns the corresponding Unicode character.

 

UNICODE Function in Excel: UNICODE function in Excel gets the character as an input and returns the corresponding Unicode Value

 

CONCATENATE Function in Excel: CONCATENATE Function in Excel joins together a set of supplied text strings or other values, into one combined text string.

 

CONCAT Function in Excel: CONCAT Function in Excel joins together a set of supplied text strings or other values, into one combined text string.

 

LEFT Function in Excel: LEFT Function in Excel returns the specified number of characters from the start of a string i.e. from left of a string.

 

RIGHT Function in Excel: RIGHT Function in Excel returns the specified number of characters from the end of a string i.e. from Right of a string.

 

MID Function in Excel: MID Function in Excel Extracts the substring from the given string. MID Function takes the String, the start of the string and length as an argument to return the substring.

 

REPT Function in Excel: REPT Function in Excel repeats the string for a specified number of times

 

LEN Function in Excel: LEN Function in Excel returns the length of a supplied text string.

 

FIND Function in Excel: FIND Function in Excel returns the position of a specified character or sub-string within a supplied text string. FIND Function is case sensitive whereas Search Function is not case sensitive.

 

SEARCH Function in Excel: SEARCH Function in Excel returns the position of a specified character or sub-string within a supplied text string. Search Function is not case sensitive whereas FIND Function is case sensitive.

 

EXACT Function in Excel: EXACT Function in Excel tests if two supplied text strings or values are exactly equal. If two values are equal then TRUE is returned, if two value are not equal then FALSE is returned.

 

T Function in Excel: T Function in Excel tests if a supplied value is text and if so, returns supplied text. If not T Function returns an empty string.

 

REPLACE Function in Excel: REPLACE function in Excel replaces all or some part of a text string with another string.

 

SUBSTITUTE Function in Excel: SUBSTITUTE Function in Excel substitutes one or more instances of a given text string with another string.

lets get started with tutorial on Excel Text Functions

next small tutorial on Excel text Functions