Counting number of unique cells in a cell

[Caleeco]

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

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

 

[jtakw]

Hi,

How about something like this:

Book1
	A	B
1	23,24,25	3
2	123	1
3	123,1,234,89	4
4	34,56789	2
Sheet148

Cell Formulas
Range	Formula
B1	=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1

 

[Caleeco]

Spot on! Many thanks for the assistance :D

 

[jtakw]

You're welcome.