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

    Count spaces in text (XL2k SR1)

    (Subject edited by HansV to make it more easily searchable)

    How do I count the number of blank spaces in a text string? I want to do it with a function rather than VBA. Thanx

    Dennis

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

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

    Re: Count spaces in text (XL2k SR1)

    One way of doing it

    =LEN(A1)-LEN(SUBSTITUTE(A1," ",""))

Posting Permissions

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