Bullets are black circle points but can also be any symbols you can use to highlight items in your list. Bullets can be alphabet letters and numbers, but did you know you can use the CHAR function to add bullets in an Excel spreadsheet? Functions in Excel are useful in doing anything like making a mathematical calculation, easily finding text in your document, and calculating dates and times. In this tutorial, we will explain how to create a bulleted list using the CHAR function in Excel. The CHAR function returns the character specified by a number. The formula for the CHAR function is CHAR(number). The syntax for the CHAR function is below:
Number: A number between 1-255 specifying which character you want.
How to create a bulleted list using a function in Excel
Follow the steps below on how to create a bulleted list using a function in Excel:
- Launch Microsoft Excel.
- Enter data or use existing data.
- Enter a formula into the cell
- Press Enter.
- See result.
Launch Microsoft Excel.
Enter data into the spreadsheet.
We have input a result heading to showcase the result of the CHAR function.
Under the Result heading, input the formula =CHAR(149). Then press Enter to see the result.
The result is a bullet point. See the photo above.
If you already had a list in your spreadsheet but want to add bullets to it using the Char function, type the formula =CHAR(149)&” “&A3.
149 is the code, and A3 is the cell that contains the data that you want to copy.
Then press Enter to see the result.
You will notice that the data in cell A3 is copied, but it has a bulleted point in front of it.
To copy the other data in the list, drag the fill handle down. You will notice that the other copied data is also bulleted.
Remove the previous list and replace it with the bulleted one.
The Char function works with codes (numbers), each number you place in the formula will give a different result. See the photo above.
There are two other methods to use the CHAR function in Excel.
Method one is to click the fx button on the top left of the Excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box, in the section Select a Category, select Text from the list box.
In the section Select a Function, choose the CHAR function from the list.
Then click OK.
A Function Arguments dialog box will open.
Type into the entry box the cell that contains the number you want to calculate.
Then click OK.
Method two is to click the Formulas tab and click the Text button in the Function Library group.
Then select CHAR from the drop-down menu.
A Function Arguments dialog box will open.
Follow the same method in Method 1.
Then click OK.
Can I create bullet points in Excel?
Yes, in Excel, you can create bullet points; you can use the CHAR function in Excel to create a bulleted list. The Chart function can place any characters in your cell by using codes that represent a special character.
READ: How to use the MID and MIDB function in Microsoft Excel
How do I insert bullet points in Excel 2010?
Follow the steps below on how to insert bullet points in Microsoft Excel 2010:
- Launch Microsoft Excel 2010.
- Double-click inside the cell where you want to type the bullet.
- Press the Alt 7 keys at the same time to enter a closed circle bullet.
What are bulleted list explain with an example?
A bulleted list is used when a person is creating a list with more than one item, for example, creating a shopping list of items to buy or making a to-do list. Bullets keep your list more organized.
What is the shortcut for inserting Bullets in Excel?
Shortcut keys are the fastest way for anyone to make commands into their spreadsheets. The shortcut keys to add bullets into an Excel cell are Alt + 7 or Alt 0149 for a solid bullet. Click the cell where you want to place the bullets and press these shortcut keys.
What is the function of Bullets?
Bullets are quite useful when adding to a list. Persons used bullets to highlight items, keep items organized and help persons with step-by-step instructions to perform a task. Bullets are usually black points, but you can also insert other characters as bullets.
READ: How to use the ASIN function in Excel
We hope this tutorial helps you understand how to create a bulleted list using a function in Excel.
