I wanted to create a list like

  • Point 1
  • Point 2
  • Point 3

in an excel cell.

Bullets and numbering is a widely used feature in microsoft word. Surprisingly microsoft excel does not have any such feature. So I did a bit of research and found the following work around.

insert the following formula in the cell where you want to put the bulleted list.
=CONCATENATE(CHAR(149),” Point 1″,CHAR(10),CHAR(149),” Point 2″,CHAR(10),CHAR(149),” Point 3″)

Keep the cursor on the cell and press Alt+Enter (“For wrap text”) and you will have your text beautifully wrapped up.

P.S If you do not want to keep the messy formula in your sheet then copy the cell and paste the value using paste special.

Popularity: 1% [?]