Separate Positive And Negative Numbers With Formula In Excel

Separate positive numbers from the list first.

Select a blank cell and type this formula =IF($A1=0,$A1,"") (A1 is the cell in your list), press Enter button and drag fill handle to fill range you want, you can see only positive values are separated into the column.

Then type this formula =IF($A1<0,$A1,"") into another column cell, and press Enter button, and drag fill handle to fill range you want. Now you can see the positive and negative values are separated into two columns.

I hope this is helpful!
Admin
O365CloudExperts