qqp question1: I would like 1 in cell B. 2 in cell c and 3 in cell D? question2: I would like to get the formula to split up amounts in a excel cell and paste it in another cell after certain characters.Cell A contains 1+2+3?