EXCEL: How do I format a cell to have mulitple bullets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Within a cell I'm attempting to create a number of bullets e.g.
1) get tickets, 2) get money, 3) take out dog

Visually can I create a list which would look like:
1) get tickets,
2) get money,
3) take out dog

The way I've done it for years was to force a wrap by adding spaces. There
must be another way. HELP didn't provide any clues.
 
Press ALT+ENTER after each bullet and resize column width, if necessary.

Original message:
 
and if you want to do the same in a concatenation formula
=A1 & Char(10) & B1
The use Alt+Enter turns on format, cells, alignment, wrap text
otherwise, you will have to turn on cell wrap yourself like when
you use concatenation.
 
Back
Top