How to Add Multiple Bullet Points in Excel Cell (5 Suitable Ways)

We have multiple names in a single cell. We will add bullet points with each line of that cell.

Method 1 – Using the Symbol Option to Add Multiple Bullet Points in an Excel Cell

Steps:

Add a column in the dataset to present data with bullet points.

Place the cursor on Cell C5.
Click on the Insert tab.
Press the Symbol option from the Symbols group.

The Symbol window appears.
Choose the Bullet sign or Character code 2022.
Press the Insert button.

Press Close.

We can see the bullet symbol on that cell.
Add the first name.

Add a line break by pressing Alt + Enter.

Add the bullet symbol (you can copy the previous symbol) and the rest of the names one by one.

Read More: How to Add Bullets in Excel Cell

Method 2 – Using a Keyboard Shortcut from a Numeric Keypad to Add Multiple Bullet Points

Steps:

Go to Cell C5.
Double-click.

Press Alt + 7.

A bullet point is added.
Add the first data after the bullet point.

We can see a line with a bullet point.
Add a line break by pressing Alt + Enter.

Repeat the process of adding bullet points and add the rest of the lines.

Method 3 – Using the CHAR Function to Add Multiple Bullet Points in an Excel Cell

Steps:

Go to Cell C5.
Insert the following formula:

=CHAR(149)

Press the Enter key.

A bullet point is added.
Add the first data using the ampersand symbol in the existing formula. The formula becomes:

=CHAR(149)&" Jessica"

We can see the first data with the bullet point.

We will add a line break using the CHAR function with the corresponding code of the line break. 10 is the code for a line break. The modified formula becomes.

=CHAR(149)&" Jessica"&CHAR(10)&CHAR(149)

Here’s the result.

Here’s the complete formula for the sample cell:

=CHAR(149)&" Jessica"&CHAR(10)&CHAR(149)&" Henderson"&CHAR(10)&CHAR(149)&" Aaron"&CHAR(10)&CHAR(149)&" Mitchel"&CHAR(10)&CHAR(149)&" John"

And here’s how it shows up.

Method 4 – Using the Copy and Paste Command to Add Multiple Bullet Points

Steps:

Go to MS Word and copy the bullet symbol.

Go back to the Excel file.
Paste the bullet symbol by pressing Ctrl + V.

Write the first data after the bullet symbol.

Add a line break by pressing Alt+ Enter.
Paste the bullet symbol again.

Repeat until you finish entering data.

Method 5 – Applying Excel VBA to Add Multiple Bullet Points in a Cell

Steps:

Right-click on the Sheet name at the bottom.
Choose View Code from the Context Menu.

This opens the VBA application window.
Press the Insert tab.
Choose the Module option.

The VBA module appears.

Put the following VBA code in the module.

Sub Add_Bullet_Points()
    Dim range_1 As Range
    Dim text_1() As String
    Dim n As Long
    Application.ScreenUpdating = False
    For Each range_1 In Selection
        text_1 = Split(range_1.Value, vbLf)
        For n = 0 To UBound(text_1)
            If Left(text_1(n), 1) <> Chr(149) Then
                text_1(n) = Chr(149) & " " & text_1(n)
            End If
        Next n
        range_1.Value = Join(text_1, vbLf)
    Next range_1
    Application.ScreenUpdating = True
End Sub