Bullets (again!)
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Bullets (again!)

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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'

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    "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"

  5. #5
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    Board Regular
    Join Date
    Mar 2002
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  7. #7
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com