It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the …

Replaces characters within text. REPT function. Repeats text a given number of times. RIGHT, RIGHTB functions. Returns the rightmost characters from a text value. SEARCH, SEARCHB …

To include text in your functions and formulas, surround the text with double quotes (""). The quotes tell Excel it's dealing with text, and by text , we mean any character, including numbers, …

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.

Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or …

Note: If you are going to use text in formulas, you need to wrap the text in quotes (e.g. “Text”). The only exception to that is using TRUE or FALSE, which Excel automatically understands.

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

Use the TEXT function to combine and format strings. The TEXT function converts a numeric value to text and combines numbers with text or symbols. For example, if cell A1 contains the …

Returns text that occurs before a given character or string. It is the opposite of the TEXTAFTER function. Syntax =TEXTBEFORE(text,delimiter,[instance_num], [match_mode], [match_end], …

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. If the delimiter is an …