How to merge bank statement into one column

Closed
Faisal - 11 Jul 2019 à 09:49
 thanks_4_nothing - 30 Sep 2019 à 16:16
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
Related:

2 responses

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
11 Jul 2019 à 11:48
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
saraparker Posts 1 Registration date Monday 30 September 2019 Status Member Last seen 30 September 2019
30 Sep 2019 à 11:03
If you right click on the column or you can select the required columns and click on merg. Automatically it will be merged.
thanks_4_nothing
30 Sep 2019 à 16:16
I did what sara posted, and it wrecked my spreadsheet!