Microsoft has been busy this last year adding new string functions to Microsoft Excel: TEXTAFTER (), TEXTBEFORE (), TEXTJOIN () and TEXTSPLIT (). They all have string management in common.

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

All you need to remember is that all the formulas need to start with a (=) sign. In the Excel sheet below, in the first table, you can see two numbers 10 and 5, which is our data.

Microsoft Excel's Clean function strips nonprintable characters from cell text. These nonprintable characters constitute the first 32 characters of the 7-bit ASCI code, which houses the 128 text c ...

These add-ons help you navigate Excel's functions and give you even more functionality, including auditing and understanding formulas, managing styles and formatting, multi-row and vertical sheet ...