2

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

1 Answer 1

5

You would need to first do a find/replace and replace - with+-.

once you have done this, Do your text to columns method you have already tried. This will split it at the + and maintain the negative numbers.

3
  • Fantastic and simple solution - thank you! :)
    – Nick
    Nov 24, 2012 at 18:14
  • Love the logic of this solution!
    – Gary
    Nov 24, 2012 at 23:41
  • Find/replace has been my friend through many a datamine. Nov 25, 2012 at 0:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .