![]() |
![]() |
![]() |
#2
|
||||
|
||||
![]() 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) |