Using text functions (reference)

Library books which symbolise text functions (reference) - Image by Image by ElasticComputeFarm from Pixabay.
  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

Introduction to using text functions (reference)

This post will teach you how to use each of the text functions (reference) and some important factors to remember when using them depending on their version markers (if relevant).

To obtain in-depth information about text functions (reference), select its name in the first column of the table underneath.

Handwritten text - text functions.
Image by Anja🤗#helpinghands #solidarity#stays healthy🙏 from Pixabay.

Vital Note:

Note: Version markers represent the version of Excel when a function was launched. These functions are absent from older versions. For example, a version marker of 2013 means that this function is available in Excel 2013 and all newer versions.

FunctionDescription
ASC functionEdits full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters.
BAHTTEXT functionConverts a number to text, employing the ß (baht) currency format.
CHAR functionReturns the character verified by the code number.
CLEAN functionDeletes all nonprintable characters from text.
CODE functionReturns a numeric code for the initial character in a text string.
CONCAT function
Excel 2016
Links the text from several ranges and/or strings, but it omits supplying the delimiter or IgnoreEmpty arguments.
CONCATENATE functionConnects multiple text items into one text item.
DBCS function
Excel 2013
Edits half-width (single-byte) English letters or katakana inside a character string to full-width (double-byte) characters.
DOLLAR functionTransforms a number into text, applying the $ (dollar) currency format.
EXACT functionScans to identify if two text values are identical.
FIND, FINDB functionsFinds one text value within another (case-sensitive).
FIXED functionFormats a number as text containing a fixed number of decimals.
LEFT, LEFTB functionsReturns the leftmost characters from a text value.
LEN, LENB functionsReturns the number of characters in a text string.
LOWER functionConverts text to lowercase.
MID, MIDB functionsReturns a unique number of characters from a text string beginning at your specified position.
NUMBERVALUE function
Excel 2013
Transforms text into number in a locale-independent manner.
PHONETIC functionExtracts the phonetic (furigana) characters from a text string.
PROPER functionCapitalises the first letter in every word of a text value.
REPLACE, REPLACEB functionsReplaces characters among text.
REPT functionRepeats text a certain number of times.
RIGHT, RIGHTB functionsReturns the rightmost characters from a text value.
SEARCH, SEARCHB functionsCaptures one text value inside another (not case-sensitive).
SUBSTITUTE functionSubstitutes new text for old text in a text string.
T functionUpdates its arguments to text.
TEXT functionFormats a number and modifies it to text.
TEXTJOIN function
Excel 2016
Merges the text from numerous ranges and/or strings, and contains a delimiter you define between each text value that will be combined. If the delimiter is an empty text string, this function will simply concatenate the ranges.
TRIM functionErases spaces from text.
UNICHAR function
Excel 2013
Returns the Unicode character which is referenced by the specific numeric value.
UNICODE function
Excel 2013
Returns the number (code point) that matches with the first character of the text.
UPPER functionAlters text to uppercase.
VALUE functionChanges a text argument to a number.
A pile of textbooks that represent text functions (reference).
Image by Hermann Traub from Pixabay.

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.

See Also

(Category)Excel functions

(Alphabetical) Excel functions

Homepage – Excel Tutorial

Leave a Reply

%d bloggers like this: