Thread: Splitting Data
View Single Post
  #1   Report Post  
jez123456
 
Posts: n/a
Default Splitting Data

Hi, I have an excel spreadsheet with 4000 rows. Sample data from the Amount
column is as follows:

Amount
£0.00
£400.00
-£20.00
-£20.00
£100.00
-£50.00
-£8.99
-£44.57
-£30.00
-£9.39
-£20.00
£100.00

Is there a quick way to seperate this data into positve and negative amounts
to give:

Credit Debit
£0.00
£400.00
-£20.00
-£20.00
£100.00
-£50.00
-£8.99
-£44.57
-£30.00
-£9.39
-£20.00
£100.00

Many Thanks