In Excel for Microsoft 365 on Windows, CHAR(149) returns a bullet character in the Windows character set; for a more dependable Unicode bullet, use UNICHAR(8226). To put a bullet before text in A2, enter =UNICHAR(8226)&" "&A2 in another cell. The result is a bullet, a space, and the text from A2.
The Excel character numbers for a bullet
The two codes readers most often need are 149 and 8226, but they belong to different Excel functions. CHAR(149) is the familiar Windows code for a filled bullet (•). UNICHAR(8226) returns the Unicode character U+2022, also a filled bullet. The displayed symbol is usually the same, but UNICHAR identifies the character by its Unicode number rather than relying on a computer’s older character set.
For a workbook created and used on Windows, CHAR(149) is a convenient answer to “what CHAR number makes a bullet?” For a workbook that may be opened on different operating systems, UNICHAR(8226) is generally the safer formula. The bullet’s appearance can still vary slightly with the font, but the Unicode code consistently specifies the bullet character.
These codes insert a character into cell content; they do not create a special list object. That distinction matters if you expect Word-style list controls, automatic indentation, or a separate bullet on every paragraph. Excel cells hold values and text, so a bullet is normally a character placed at the beginning of text.
How CHAR and UNICHAR work
CHAR converts a number from the character set used by the computer into a character. In Windows Excel, the familiar bullet is at 149 in the relevant character set. CHAR is useful for inserting characters by number, but its result can depend on the system character set. That is why the same CHAR number is not the best choice when a workbook will move between Windows and Mac computers.
UNICHAR converts a Unicode number into its corresponding character. Unicode assigns the standard bullet the decimal value 8226, so UNICHAR(8226) expresses the intended symbol directly. The number is decimal, not hexadecimal: the Unicode label U+2022 is another way to identify the same character, but the Excel function takes 8226.
Neither function changes how Excel stores the rest of the cell. When you join a bullet to a label with the ampersand operator, the result is text. If the source cell contains a number, joining it to a bullet also produces text, which may affect later calculations or sorting. Keep the original numeric value in a separate cell if you need to calculate with it.
Add a bullet with a formula
Suppose A2 contains the text Call supplier. To create a bulleted version in B2, enter this formula in B2:
With the label in A2, enter =UNICHAR(8226)&" "&A2. The result is • Call supplier.
For Windows-only workbooks, the equivalent CHAR formula is =CHAR(149)&" "&A2. Both formulas join three pieces: the bullet, a space, and the text in A2. The space is included explicitly because the character code alone does not add one.
To apply the formula to a list, copy it down from B2 using the fill handle, the small square at the lower-right corner of the selected cell. Excel adjusts A2 to A3, A4, and so on. If a source cell might be blank and you do not want a bullet to appear beside an empty label, use this version instead:
With list text in A2 and the formula in B2, enter =IF(A2="","",UNICHAR(8226)&" "&A2). A blank A2 produces a blank B2; otherwise B2 shows the bullet and label. Copy the formula down for the rest of the list.
These formulas create a display column and leave the source text untouched. If you need the final list to be plain text rather than formulas, copy the results and use Paste Special > Values. That replaces the formulas with their displayed text. Keep a copy of the original column if you may later need to edit the source labels or rebuild the list.
Put several bullet items in one cell
If each list item needs its own line inside one cell, join the items with a line break as well as a bullet. For example, suppose A2 contains Buy labels and B2 contains Print forms. A formula can place both items in one cell on separate lines:
With the two items in A2 and B2, enter =UNICHAR(8226)&" "&A2&CHAR(10)&UNICHAR(8226)&" "&B2. The result is two bullets in one cell, with a line break between them.
Turn on Home > Wrap Text for the result cell so the line break is visible as a new line. You may also need to adjust the row height; use Home > Format > AutoFit Row Height if the second item is hidden. CHAR(10) is the line-feed character used for an in-cell line break in this formula. On Windows, Alt+Enter while editing a cell can also insert a line break manually.
For a longer list, it is often easier to keep one item per row and use one bullet formula per row. A single cell containing many line breaks can be harder to filter, sort, edit, and reference in other formulas. Choose the layout based on how the list will be used, not just how it looks on the sheet.
Insert a bullet without a formula
For a short, fixed list, you can insert a bullet directly rather than building it with a formula. In desktop Excel, select a cell, choose Insert > Symbol, select a font and the bullet character, and insert it. The available symbols and dialog appearance can vary with the selected font. You can also copy this character and paste it into a cell: •
On Windows, Alt+0149 on the numeric keypad is a common way to type the bullet while editing cell content. Use the numeric keypad, not necessarily the number row above the letters; laptop layouts may require enabling a keypad or using a different input method. On Mac, Option+8 types a bullet in many text-entry contexts. Keyboard behavior can depend on keyboard layout and app focus, so inserting the glyph or using UNICHAR is a practical alternative if a shortcut does not work.
Excel does not provide the same prominent Bullets button for cell text that Word provides for paragraphs. Directly inserted bullets are handy for a small, static set of labels, while formulas are easier to repeat across many rows or update from source text. In Excel for the web, use a formula such as UNICHAR or paste the bullet if the desktop Symbol dialog is not available in your interface.
Choose the right method for the job
The best option depends on whether the list is fixed, formula-driven, or intended to behave like a real list. Use the following guide:
- Use UNICHAR(8226) when you want a reliable formula-based bullet across Windows and Mac versions of Excel.
- Use CHAR(149) when the workbook is intended for Windows and you specifically want the familiar Windows character code.
- Insert or paste the glyph for a few fixed entries that will not need to update from another cell.
- Use one item per row when sorting, filtering, or managing list entries is important.
- Use multiple lines in one cell when the list is a compact note and should stay together as a single cell value.
A custom number format can display a prefix for certain numeric values, but it is not a replacement for adding a bullet to arbitrary text: custom formats mainly control how numbers, dates, and related values appear. For ordinary text lists, use a character, formula, or a separate bullet column. If you want formal multilevel lists with automatic indentation, a document or presentation app may fit better than a worksheet.
Common problems and fixes
The formula shows #NAME? Check the function spelling and the opening parenthesis. The function is UNICHAR, not “UNICHR” or “UNICHARACTER.” Excel formulas must begin with an equals sign. If you typed the formula into a cell formatted as Text, Excel may display the formula instead of calculating it; change the cell to General, then re-enter the formula.
The character looks like a square or a different symbol. A font may not contain or display the expected glyph. Try a common font such as Arial or Aptos, and check that the function is returning the intended character. UNICHAR(8226) specifies the Unicode bullet, but the font controls its visual design. A different bullet shape can be chosen by using another character, but verify its appearance in the fonts and devices your readers use.
CHAR(149) differs on another computer. CHAR depends on the character set used by the system, so a workbook shared between operating systems can display a different result for some codes. Replace the formula with UNICHAR(8226) when portability matters. Also remember that older file formats or applications may handle Unicode differently; check the workbook in the software and fonts used by its recipients.
The bullet appears but there is no gap after it. CHAR and UNICHAR return only the character. Add a literal space in the formula, as in =UNICHAR(8226)&" "&A2, or type a space after a manually inserted bullet. If the bullet is too close to the cell edge rather than the text, adjust the column width or alignment; a space in the value does not create a full list indent.
The bullet is part of the text when sorting. That is expected: formulas that join a bullet and label return text. If sorting alphabetically by the original label matters, sort by the source-label column, not the display column. Keeping content and presentation in separate columns makes it easier to filter and reuse the underlying values.
Frequently Asked Questions
What is the CHAR number for a bullet in Excel?
For Windows Excel, the commonly used code is CHAR(149). For a platform-independent Unicode bullet, use UNICHAR(8226).
What is the formula to add a bullet before text in A2?
Enter =UNICHAR(8226)&" "&A2 in another cell. It displays a bullet, a space, and the contents of A2.
Does CHAR(149) work on Mac?
CHAR uses the computer’s character set, so its output may differ between operating systems. Use UNICHAR(8226) when the workbook needs the standard Unicode bullet on Windows and Mac.
How do I put two bullet points in one Excel cell?
Join each bullet and item with CHAR(10) between them, then turn on Home > Wrap Text. Adjust the row height if needed so both lines show.
Can I use Alt+7 to type a bullet?
Alt-key results depend on the keyboard, numeric keypad, and character set, so Alt+7 is not a dependable universal method. On Windows, Alt+0149 is a common numeric-keypad entry; on Mac, Option+8 commonly types a bullet. A formula or pasted symbol is more consistent when shortcuts vary.
Related
- Cell in Microsoft Excel: Meaning, Types, and How to Use It
- Count Numbers vs Count in Excel PivotTables
- Copy Paste in Excel: Keep Column Widths When Pasting
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Microsoft Excel Keyboard Shortcuts: A Practical GuideThere is no single, short list of every Microsoft Excel keyboard shortcut: available commands vary by operating system,…
- Compare Lists in Excel: Find Matches and DifferencesWith values in A2:A6 and B2:B5, enter =IF(COUNTIF($B$2:$B$5,A2)>0,"In both","Only in A") in C2 and fill it down to…
- Create Rules in Gmail Like Outlook: A Step-by-Step GuideTo create rules in Gmail, set up a filter: choose the messages it should match, then tell Gmail…
- Excel Automatically Splitting Text to Columns? Here’s WhyExcel does not normally split text into separate columns just because you type or paste a comma-separated phrase…
- Excel Print Area Lines: How to View, Set, and Hide ThemYes. In Excel for Microsoft 365 on Windows, the clearest way to see your print area is to…
- Sum in Excel in Different Rows: Quick MethodsTo add values from separate rows in Excel, enter a SUM formula that names the cells you want…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.