+ Reply to Thread
Results 1 to 2 of 2

number of character occurences in a cell

  1. #1
    Ron
    Guest

    number of character occurences in a cell


    Hello,

    Can anyone tell me if there is an excel built in function
    that will count the number of occurences of a character in
    a cell? For example, if cell D5 is "11,2,35,4" and I want
    to count the number of commas in the cell, the result
    should be 3.

    thanks
    Ron

  2. #2
    Domenic
    Guest

    Re: number of character occurences in a cell

    Try...

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

    Hope this helps!

    In article <208201c52e31$959b3820$a401280a@phx.gbl>,
    "Ron" <anonymous@discussions.microsoft.com> wrote:

    > Hello,
    >
    > Can anyone tell me if there is an excel built in function
    > that will count the number of occurences of a character in
    > a cell? For example, if cell D5 is "11,2,35,4" and I want
    > to count the number of commas in the cell, the result
    > should be 3.
    >
    > thanks
    > Ron


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1