Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Blue Springs, Missouri, USA
    Posts
    108
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Repeating characters (XL2K SR1)

    In the old Lotus 1-2-3... you used to be able to put a repeating character in a cell (I think this was it)... that is... if you proceeded a character with then it would repeat endlessly within the cell so that no matter how wide the cell was, the cell was always filled with that character. Is there such a thing in Excel?

    Thanx

    Dennis

    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Brussels, Brussel, Belgium
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repeating characters (XL2K SR1)

    hi Dennis,

    format->cells...->alignment->text alignment (horizontal)->fill.

    greetings,

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Repeating characters (XL2K SR1)

    There is =REPT() for a repeat function, and also see some of the formatting options to repeat characters in <!post=this,217088>this<!/post> thread.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Repeating characters (XL2K SR1)

    Hi Dennis,

    You can do this with a custom format (Format|Cells|Number|Custom).
    To create a format with dot leaders ahead of, or trailers behind a, the cell
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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