Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Park City, Utah
    Posts
    189
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Minimum Text Cell Length 25 Characters

    Hi all,

    We need to have a minimum of 25 characters in a cell containing people's names. So how to I add spaces to make the cell 25 characters?

    It doesn't matter if the text is longer than 25, just hast to be a minimum of 25. I'm "assuming" I need to get the cell length, subtract it from 25 and add that many spaces. (Yes, I passed algebra, a long, long time ago!)

    Thank you so much for your help,

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If the cell is in A1 you could use:

    =A1&REPT(" ",MAX(0,25-LEN(A1)))

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    jeanieb (2011-01-18)

  4. #3
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 Posts
    Why do you need 25 characters?

    cheers, Paul

Posting Permissions

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