title: Count number of numbers in a single cell
body: <p>I want to count the number of numbers in a single cell.</p>
  
  <p>Example: </p>
  
  <p>In cell A1, I have the following addition: </p>
  
  <p><code>=12+45+23+51+10</code> which totals (and shows) <code>141</code>.</p>
  
  <p>In cell B1, I would like the see how many numbers have been added together, which means that there should be 5 (12 is a number, 45 another one, etc... and all together, there are 5 numbers in cell A1).</p>
  
  <p>I know it seems to be a ridiculous question, but I scanned all the platforms for this issue and did not find any suitable solution. Tried all the <code>LEN</code> and <code>LEN SUBSTITUTE</code> alternatives out there, but somehow it does not work. </p>
  
  <p>Thank you upfront for your help. Optimal solution would be a excel formula, alternatively VBA would also work. </p>