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…