ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I perfom a character count in a single cell in Excel? (https://www.excelbanter.com/new-users-excel/104530-how-do-i-perfom-character-count-single-cell-excel.html)

RonNette72791

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.

Miguel Zapico

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.



All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com