Count numbers within text
Closed
Useful
-
16 Feb 2010 à 08:33
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Feb 2010 à 09:34
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Feb 2010 à 09:34
Related:
- Count numbers within text
- Excel count occurrences - Guide
- Count names in excel - Guide
- How to hide subscriber count - Guide
- Mysql count occurrences of value in column - Programming Forum
- How to count sentences in a paragraph ✓ - Programming Forum
3 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Feb 2010 à 08:36
16 Feb 2010 à 08:36
what you mean count numbers with in text? Could you explain with example
I have many texts like that 5Fiesta75 and Iwant to count the how many number are there (within this text)
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Feb 2010 à 09:01
16 Feb 2010 à 09:01
You have to create a user defined function in VBA and use it to get the number of digits in a word
Thanks for you answer. I can solve this problem by another way bat I want to solve this problem using by formula
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Feb 2010 à 09:34
16 Feb 2010 à 09:34
Other idea that I can think of is that use SUBSTITUTE to remove all digits. The difference in length before and after sub, can give you that answer too
=LEN(B1) - LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1,1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,""),0,""))
=LEN(B1) - LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1,1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,""),0,""))
