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 …

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 …

This is because the DOLLAR function returns the number provided as text. Numbers stored as text are a common cause of spreadsheet errors, because many functions ignore them, such …

Lists all Excel functions by their category, such as Logical functions or Text functions.

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

FIND locates one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.

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.

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).

LEFT returns the first character or characters in a text string, based on the number of characters you specify.

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.