In this tutorial, we will explain how to create a bulleted list using the CHAR function in Microsoft Excel. Bullets are black circle points but can also be any symbol.

The CLEAN () function in Excel removes all non-printable characters from a given text string. It is the easiest and the most direct way of removing non-printable characters in Excel.

It's easy to return random values in Microsoft Excel, but returning random letters might leave you scratching your head. Fortunately, you only need two functions.

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER() and TEXTBEFORE() in this tutorial.