TEXT function - Microsoft Support
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 …
Text functions (reference) - Microsoft Support
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 …
Date and time to text - Microsoft Support
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: …
Excel functions (by category) - Microsoft Support
Lists all Excel functions by their category, such as Logical functions or Text functions.
TEXTAFTER function - Microsoft Support
It returns the entire text when searching from the front (if instance_num is positive) and empty text when searching from the end (if instance_num is negative).
DOLLAR function - Microsoft Support
The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the …
Combine text from two or more cells into one cell in Microsoft Excel
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
MATCH function - Microsoft Support
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.
Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
MID function - Microsoft Support
In Excel, the MID function returns the specific number of characters in a string starting at the position you specify