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: - (required) the text (typically a cell reference) to be shown in bulleted format
- (optional) nudge left indent for wrapped lines (default is 0)
- (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: - (required) the text (typically a cell reference) to be shown in list-numbered format
- (optional) adjust the starting list number, 1, of the cell by X (default is 0)
- (optional) nudge left indent for wrapped lines (default is 0)
- (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: |
|
