[SentToStud]

Originally Posted by SentToStud

use spaces, not commas. also enter the four numbers into the cell like this:

'1 3 5 6

then try this:
=IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1)

Scav, it should work with commas in the cell also.