Try this one

U have data in A1 in B1 put this formula =REPLACE(",",
1,1,"+")&SUBSTITUTE(A3,",","+")

and then copy | go to Edit | paste special | values | ok |



On Sep 8, 3:16*am, Francois Taljaard <Francois
wrote:
Hi

Need to split cell values and sum.
Cell A1: 0,20,300,20,300 *
Cell A2: 280,34,200,129,0

Result for A1 = 640
Result for A2 = 643

Note that the length of cell and values are not consistent.

Any help much appreciate.