formating text cells

C

Cathyinliberty

I need to format a text cell using bullets similiar to Word's bullets and
numbering? Any idea on how to do that? Can Excell automatically generate
the bullet?
 
T

tjtjjtjt

Excel doesn't support this the way Word does. I'd use Word, if at all possible.
One alternative in Excel:
If you put the text of the bullet point in B1, put this in A1 to generate a
"bullet":
=IF(B1<>"",CHAR(149),"")
Copy this down as far as needed.

You will likely want to use Align Right on Column A as well. Not a bad idea
to adjust the width of Column A, either.

tj
 
G

Gord Dibben

Cathlyn

Format>Cells>Number>Custom

Hold down ALT key and type 0149(from numpad) then a space then @

Returns • Cathlyn or • Gord

Whatever text is typed in gets a bullet.

Gord Dibben Excel MVP
 
Top