Excel - Formula in text count
Solved/Closed
Related:
- Excel - Formula in text count
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Gif in excel - Guide
- How to count names in excel - Guide
3 responses
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Mar 5, 2010 at 04:57 AM
Mar 5, 2010 at 04:57 AM
Hello,
Try with this formula, I supposed the text is into A1 :
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1,"P","")))
Best regards
Try with this formula, I supposed the text is into A1 :
=SUM(LEN(A1)-LEN(SUBSTITUTE(A1,"P","")))
Best regards
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 5, 2010 at 03:41 AM
Mar 5, 2010 at 03:41 AM
if you want to count the cell, then you can use COUNTA function
Below example count number of cells that are not blank
=COUNTA(A1:A10)
Below example count number of cells that are not blank
=COUNTA(A1:A10)
