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.

This poses a problem when you actually need to concatenate the double quotation marks themselves. However, Excel has a special character function that allows you to enter such marks.