Simply write you list in Word and copy and paste it into excel.

Or copy your list to Word, make it bulleted, and copy it back.

Regards

Doug

On Thursday, September 06, 2007 4:31 AM Terry Bennett wrote:

Is there any way of creating bullet points (as in Word) within cells in
Excel?

Sometimes I find it useful to separate comments within a cell and wonder
whether there is a way of doing this other than simply typing the '-' key
manually at the commencement of each new point.

Thanks.


On Thursday, September 06, 2007 5:24 AM Gav12 wrote:

Hi Terry,

I don't think you can have bullet points, maybe you do this already but you
might find it easier to seperate your comments by using ALT+ENTER (which
starts a new line in the cell) and then "-" for each comment.

Regards,

Gav.


"Terry Bennett" wrote:


On Thursday, September 06, 2007 5:31 AM Chip Pearson wrote:

I think you would have to do it with code. Select the range and then run
this code.

Sub MakeBulletList()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
If Rng.IndentLevel = 0 Then
Application.EnableEvents = False
Rng.Formula = "=CHAR(7)&"" " & Rng.Text & """ "
Application.EnableEvents = True
Rng.IndentLevel = 1
End If
End If
Next Rng
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Terry Bennett" wrote in message
...


On Thursday, September 06, 2007 5:35 AM Terry Bennett wrote:

Thanks Gav - that is what I am doing at present.


On Thursday, September 06, 2007 5:52 AM Terry Bennett wrote:

Thanks Chip


On Thursday, September 06, 2007 6:26 AM MartinW wrote:

Hi Terry,

Not that this addresses your actual question, but if you use
Alt+0149 instead of - you will get a bullet instead of a dash

(to use unicode hold down Alt key type the numbers on the Number
Pad then let go the Alt key)

HTH
Martin



"Terry Bennett" wrote in message
...


On Thursday, September 06, 2007 10:56 AM Terry Bennett wrote:

Thanks Martin