+ Reply to Thread
Results 1 to 2 of 2

How do I perfom a character count in a single cell in Excel?

  1. #1
    RonNette72791
    Guest

    How do I perfom a character count in a single cell in Excel?

    I need to peform a character count for certain cells in Excel. I found a
    formula for counting words within a cell but not the number of specific
    characters.

  2. #2
    Miguel Zapico
    Guest

    RE: How do I perfom a character count in a single cell in Excel?

    If you count spaces as a character, you can use directly the function LEN.
    If you don't want the spaces to count, use something like:
    =LEN(SUBSTITUTE(A1," ",""))

    Hope this helps,
    Miguel.

    "RonNette72791" wrote:

    > I need to peform a character count for certain cells in Excel. I found a
    > formula for counting words within a cell but not the number of specific
    > characters.


+ 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