Thread: [Solved] Help with LEN and Substitute function
View Single Post
 
Old 11-07-2014, 07:59 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default
Hi Nat

I rather would go with this:
=IF(OR(F20="",F20=0,F20="0"),0,LEN(F20&",")-LEN(SUBSTITUTE(F20,",","")))

Cheers
Reply With Quote