The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable …

Mar 14, 2012 · Date and time to text The TEXT function in Excel converts a date or time to text in a specified format. The syntax is: =TEXT (value, format_text) Examples: Format today's date: …

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

How to use the INDIRECT function in Excel to change the reference to a cell within a formula without changing the formula itself.

How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.

Learn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined.

In Excel, the MID function returns the specific number of characters in a string starting at the position you specify

This article describes the formula syntax and usage of the RIGHT function in Microsoft Excel. Description RIGHT returns the last character or characters in a text string, based on the …

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 …