Caleeco
Well-known Member
- Joined
- Jan 9, 2016
- Messages
- 980
- Office Version
- 2010
- Platform
- Windows
Hello,
Got an Excel problem I'm struggling to solve. I need to be able to count the number of Numbers in a cell. So if a cell contained the text
The output would be 3
Is there a way to do this? I suppose the easiest way would be to count the commas? but.. there may be entires with a single number
Any help is appreciated
Many Thanks
Caleeco
Got an Excel problem I'm struggling to solve. I need to be able to count the number of Numbers in a cell. So if a cell contained the text
Code:
23,24,25
The output would be 3
Is there a way to do this? I suppose the easiest way would be to count the commas? but.. there may be entires with a single number

Any help is appreciated
Many Thanks
Caleeco