MS Excel - splitting a formula into individual cells?
- by Nick
I'm not sure if this is possible, or if I'll have to do it manually, but I have lots of cells in the following format:
=87.12+56.52-16.50+98.21-9.51
If possible, I'd like to break it up into columns, like so:
I have a data in excel in the format:
87.12 | 56.52 | -16.50 | 98.21 | -9.51
I've tried text to columns based on the '+' symbol, but it falls short when I then try to break it down by the '-' symbol, it moves into columns as appropriate, it removes the minus from the start of the figure
Any suggestions would be very welcome! Thank you