I am working on an Excel sheet which has Amounts added in it and I want to
break it up into individual cells

Example in Cell A1 I have the following =1500+500+300+100+500
As such the final value shown in Cell A1 is 2900

Now I want this values to be splitted and shown in different cells
Eg A2 = 1500 , A3=500, A4=300, A5=100,A6=500 and Total in A7=2900

Does it have to be a formula or macro? Or are you just looking for a method
to break the cell up into individual cells one time?

If you need a formula or code solution, are the operations always additions
or could there be other math operations mixed in (multiplication,
subtraction, division, other)? Can the number of items being "added" vary?
Or will there always be 5 of them?

Here is the manual method to do what you asked. Select A1 and click
Data/TextToColumns from Excel's menu (if the cells next to A1 have data in
them, you will need to copy the contents of A1 to a cell where the cells to
its right are empty and do the following to that cell instead). On the
dialog that appears, select the Delimited option and click Next. Check the
CheckBox labeled "Other" and put a plus (+) sign in the fill-in field next
to it. Click the Finish button. Now, on the spreadsheet, select all of the
cells that were created and Copy them into the Windows Clipboard (Ctrl+C)
and then click into the A2 cell and select Edit/PasteSpecial from Excel's
menu, Now, put a check in the CheckBox labeled "Transpose" and click OK.
This will copy the cells to where you wanted. Finally, delete the cells in
row 1 that were created from A1.

Rick