David

You could use a formula approach eg in col B:

=If(A1<0,A1,"")

and col C:

=IF(A1=0,A1,"")

copied down. Then you'd have to copy and paste values.

Simple, but it works!

Richard


Prospect wrote:

I have a large column of numbers, some postive and some negative. I would
like to separate these into two columns, one for positive and one for
negative. Is there a quick way of doing this?
--
David