Thread: Excel Question
View Single Post
  #2  
Old 01-16-2008, 05:26 PM
SentToStud's Avatar
SentToStud SentToStud is offline
Arlington Park
  
Join Date: May 2006
Posts: 4,065
Default
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)
Reply With Quote