Returns the length of a supplied text string Joins together two or more text strings, separated by a delimiter (New in Excel 2016 (or Excel 2019 for Mac)) Returns a string consisting of a supplied text string, repeated a specified number of times Returns a specified number of characters from the end 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 start of a supplied text string 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 (or Excel 2019 for Mac) - replaces the Concatenate function) Returns the number (code point) corresponding to the first character of a supplied text string (New in Excel 2013)Ĭutting Up & Piecing Together Text Strings Returns the Unicode character that is referenced by the given numeric value (New in Excel 2013)
Returns the numeric code for the first character of a supplied string Returns the character that corresponds to a supplied numeric value Rounds a supplied number to a specified number of decimal places, and then converts this into textĬonverts a supplied value into text, using a user-specified formatĬonverts a text string into a numeric valueĬonverts text to a number, in a locale-independent way (New in Excel 2013)Ĭonverting Between Characters & Numeric Codes
letters that do not follow another letter are upper case and all other characters are lower case)Ĭonverts all characters in a supplied text string to upper caseĬonverts a number, plus the suffix "Baht" into Thai textĬonverts a supplied number into text, using a currency format Removes duplicate spaces, and spaces at the start and end of a text stringįunctions to Convert Between Upper & Lower CaseĬonverts all characters in a supplied text string to lower caseĬonverts all characters in a supplied text string to proper case (i.e. Removes all non-printable characters from a supplied text string Excel Built-In Function Categories:Įxcel Text Functions Functions to Remove Extra Characters Each of the function links will take you to a dedicated page, where you will find a description of the function, with examples of use and details of common errors.Īlternatively, if you know the name of the function you are interested in, you may prefer to select from the alphabetical functions list. This page provides a complete Excel Functions list, grouped by category. These functions are organised into categories (text, logical, math, etc.) to help you to locate the function you need from the Excel menu. Excel provides a large number of built-in functions that can be used to perform specific calculations or to return information about your spreadsheet data.