Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    count number of spaces in a cell (Excel 2002 SP3)

    Is there a way to count the number of blank spaces in a cell?

    thanks in advance,

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: count number of spaces in a cell (Excel 2002 S

    Hi Dave

    Try this:
    <code>=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))</code>

Posting Permissions

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