How to merge bank statement into one column

Report
-
 thanks_4_nothing -
Hello,
how can I merge bank statement credit transaction with debit transaction in excel into one column? Considering credit transaction should be in negative in accordance with accounting


System Configuration: Windows / Firefox 67.0

2 replies

Posts
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020
396
Hi Faisal,

Better keep them separated to do calculations with them. But if you really want to put 2 cell values into 1 cell:
=A2 & " " & B2

Best regards,
Trowa
Posts
1
Registration date
Monday September 30, 2019
Status
Member
Last seen
September 30, 2019

If you right click on the column or you can select the required columns and click on merg. Automatically it will be merged.

I did what sara posted, and it wrecked my spreadsheet!