Bulleted and numbered lists: update

posted Dec 14, 2016, 10:03 AM by Ezra Kenigsberg   [ updated Dec 14, 2016, 10:09 AM ]
Q: "How do I create bulleted and numbered lists within a cell in Excel?"

A: Short answer: download this add-in, activate the add-in in Excel (File | Options | Add-Ins), and use the functions =BULLET() and =NUMBER().

Long answer: I posted about this three years ago (gosh, time flies). It took me that long to realize that I shoulda written it to accept quoted text within the cell, like this:
(in case you forgot, hard returns are entered in Excel by pressing Alt+Enter). The result looks like this:
I narrowed the column to show how nicely =BULLET() formats it. Check out those groovy hanging indents. Lovely!

The BULLET() function takes up to three arguments:
  1. (required) the text (typically a cell reference) to be shown in bulleted format
  2. (optional) nudge left indent for wrapped lines (default is 0)
  3. (optional) nudge right margin for all lines (default is 0; positive numbers make lines longer, negative numbers make lines shorter)
The NUMBER() function takes up to four arguments:
  1. (required) the text (typically a cell reference) to be shown in list-numbered format
  2. (optional) adjust the starting list number, 1, of the cell by X (default is 0)
  3. (optional) nudge left indent for wrapped lines (default is 0)
  4. (optional) nudge right margin for all lines (default is 0; positive numbers make lines longer, negative numbers make lines shorter)
Added bonus for Jira fans! Here's how ya do bullets embedded in numbered lists (and vice versa) in Jira:
Comments