How to merge bank statement into one column

- - Latest reply: TrowaD
Posts
2501
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 16, 2019
- Jul 11, 2019 at 11:48 AM
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
See more 

1 reply

Posts
2501
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 16, 2019
356
0
Thank you
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
Respond to TrowaD