How to merge bank statement into one column

Closed
Faisal - Jul 11, 2019 at 09:49 AM
 thanks_4_nothing - Sep 30, 2019 at 04:16 PM
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 September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 11, 2019 at 11:48 AM
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
0
saraparker Posts 1 Registration date Monday September 30, 2019 Status Member Last seen September 30, 2019
Sep 30, 2019 at 11:03 AM
If you right click on the column or you can select the required columns and click on merg. Automatically it will be merged.
-2
thanks_4_nothing
Sep 30, 2019 at 04:16 PM
I did what sara posted, and it wrecked my spreadsheet!
0