Bulleted list

[publish]

Help, please. I need to create a bulleted list in ONE cell.

So it should look like this

• Thing 1
• Thing 2
• Thing 3

The catch is the data is in multiple, separate horizontal cells. How could I combine the horizontal data vertically and then turn it into a bulleted list in a single cell?

 

[deanst]

HI - try this, assuming your data is in cells A1, B1 and C1.

Make sure Wrap text is turned on for the cell you are putting the formula in otherwise it won't work.

=CHAR(149) & "    " &  A1 & CHAR(10) & CHAR(149) & "    " &  B1 & CHAR(10) & CHAR(149) & "    " &  C1 & CHAR(10)

Dean.