Excel: Dividing comma separated single cell numbers
<p>I have a string of numbers in a single Excel cell separated by commas, e.g. <code>A2 = "4,3,2,7"</code>.  I want a formula to be able to divide those number by 2 in cell <code>B2</code>, e.g. <code>B2 = "2,1,1,3"</code> (odd numbers should round down rather than up)</p>

<p>The formula needs to be able to account for:<br>
- smaller or larger string of numbers<br>
- for both single and double digit numbers<br>
- numbers that are even or odd<br>
- no VBA<br>
- formula can use multiple columns but not the delimited text to columns feature (due to cell location)</p>

<p>I was able to get a formula to sum the string of numbers in <code>A2</code> <code>(4,3,2,7 = 16)</code> but not able to divide by 2.  My formula to sum the string is below.  Any help is appreciated, thanks!</p>

<pre><code>{=SUM(IF(ISERR(VALUE(MID(A2,ROW($A$1:OFFSET($A$1,LEN(A2)-1,0‌​)),1))),0,VALUE(MID(‌​A2,ROW($A$1:OFFSET($‌​A$1,LEN(A2)-1,0)),1)‌​)))}
</code></pre>