Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

up vote 5 down vote accepted

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.

share|improve this answer
    
Fantastic and simple solution - thank you! :) –  Nick Nov 24 '12 at 18:14
    
Love the logic of this solution! –  Gary Nov 24 '12 at 23:41
    
Find/replace has been my friend through many a datamine. –  Jared Tritsch Nov 25 '12 at 0:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.