![]() |
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. |
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