Column Separation Question

[carlton7372]

Hello Forum,

I have downloaded snippet of the accounts. However, the amounts include both money in(+) and money out(-) in the same column called 'Amount'. Can someone show me how wirte a simply program to separate the two payments into different columns please, see attached.

Cheers

Carlton

[newdoverman]

Insert 2 columns IN and OUT (you can call then whatever you like) in columns E and F
Enter this in E2 and fill down.

Please Login or Register  to view this content.

Enter this in F2 and fill down.

Please Login or Register  to view this content.

	A	B	C	D	E	F	G	H
1	Number	Date	Account	Amount	IN	OUT	Subcategory	Memo
2		10/12/2015	xxxxxxxxxxxx	-3.7		-3.7	PAYMENT	PRET A MANGER
3		10/12/2015	xxxxxxxxxxxx	-38		-38	PAYMENT	PHOTO-LOAND
4		10/12/2015	xxxxxxxxxxxx	700	700		FT	MONEY
5		10/12/2015	xxxxxxxxxxxx	-1350		-1350	PAYMENT	MBAGS
6		09/12/2015	xxxxxxxxxxxx	-1.55		-1.55	PAYMENT	PRET A MANGER
7		09/12/2015	xxxxxxxxxxxx	153.74	153.74		PAYMENT	paypal
8		09/12/2015	xxxxxxxxxxxx	-1.2		-1.2	PAYMENT	SAINSBURYS
9		08/12/2015	xxxxxxxxxxxx	-1.55		-1.55	PAYMENT	PRET A MANGER
10		08/12/2015	xxxxxxxxxxxx	10	10		DIRECTDEBIT	Payment
11		07/12/2015	xxxxxxxxxxxx	100	100		BBP	PVERSION

You can then hide column D to clean things up.

[carlton7372]

Thats great.

Thanks

[newdoverman]

Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.