Bullets (again!)

[chookers]

Good God, glad the board is sorted out. Well this is the 4th time I've posted this thing -hopefully someone will able to see it now!

Is there a way to put a bulleted list in a cell??? I don't see anything in help that says 'YES YOU CAN' - thought I would try here just to put my mind at rest -

Thank you!

[anno]

chookers
as far as i know you can't do bulleted lists (not in xl97 anyway) but you can use alt+enter to start a new line in the same cell and precede the text on each line with a dash or asterisk or something similarly 'bulletish'

[chookers]

Yes that's what I thought - am using Office 2000, if anyone else knows of how I can use actual bullets, let me know!

Also It seems when your first entry into a cell is a 'dash', it wants to do some sort of formatting and gives you error messages so I can only use a dash if it's not the first entry.

Thanks!

[anno]

"Also It seems when your first entry into a cell is a 'dash', it wants to do some sort of formatting and gives you error messages so I can only use a dash if it's not the first entry. "

if you can't find a better solution and are stuck with using dashes, to get around the 'error' thing try enclosing everything in quotation marks ="-text"

[Jay Petrulis]

Hi,

At least three ways:

1. Enter the following in any cell
=CHAR(149) & " Hi there"
and you will get a bullet before the text.

2. Hold down the Alt key and type 0149 on the keyboard. Alt+0149 and then your text.

3. l,n,u with Wingdings fonts will give you a bullet.

You can also import them from Word or use the character map (char.exe) to choose.

Bye,
Jay

[andy-s]

I've had the same challange, and my solution was:

1) Hit the A1 cell - then Format, Cells, Fonts - Wingdings
2) write =IF(B1<>"","l","")in the A1 cell
3) write something in the B1 cell and hit enter

andy-s


[ This Message was edited by: andy-s on 2002-04-15 15:36 ]

[Yogi Anand]

Andy, adding to what you just described. one would naturally have to narrow the width of column A to suit, so the columns A and B taken together will giv ethe impression of an integrate bulleted list!

[Exactement]

If you just want to add a bullet at the start of a cell or cells (as opposed to a bulleted list within one cell), try this macro :-

Sub Add_Bullet()
Dim bullet As String, cell As Range
bullet = Chr(149) & Chr(32)
For Each cell In Selection
If Left(cell.Value, 2) <> bullet Then cell.Value = bullet & cell.Value
Next
End Sub