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.

You can’t just plug in the asterisk character though. When adding wildcards to a function in this way, you must concatenate the delimiter and the reference.

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...