The functions have been grouped by category, to help you to find the function you need. Each function link provides a full description of the function, with examples of use and common errors. Note that some of the Excel functions listed below are new to Excel 2013 or Excel 2016, so are not available in earlier versions of Excel.
To Remove Extra Characters
Removes all non-printable characters from a supplied text string.
Removes duplicate spaces, and spaces at the start and end of a text string.
To Convert Between Upper & Lower Case
Converts all characters in a supplied text string to upper case
Converts first character of each word to upper case.
Converts all characters in a supplied text string to lower case.
To get a Substring from the main string
Returns a specified number of characters from the start of a supplied text string.
Returns a specified number of characters from the middle of a supplied text string.
Returns a specified number of characters from the middle of a supplied text string.
Searching a substring in the main string
Returns the position of a supplied character or text string from within a supplied text string (case-sensitive).
Returns the position of a supplied character or text string from within a supplied text string (non-case-sensitive).
Replacing / Substituting Parts of a Text String
Replaces all or part of a text string with another string (from a user supplied position).
Substitutes all occurrences of a search text string, within an original text string, with the supplied replacement text.
To get the length of a string
Returns the length of a supplied text string
Joining Texts
Joins together two or more text strings (Replaced by Concat function in Excel 2016).
Joins together two or more text strings (New in Excel 2016 – replaces the Concatenate function).
Returns a string consisting of a supplied text string, repeated a specified number of times.
Joins together two or more text strings, separated by a delimiter (New in Excel 2016).
To Compare two texts
Tests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive).