Menu
Ask a question Report

How to merge bank statement into one column

- - Latest reply: TrowaD
Posts
2519
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 3, 2019
 - Jul 11, 2019 at 11:48 AM
Excel Ask a question Report
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

Report Respond to TrowaD
Posts
2519
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 3, 2019
 361
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
Reply Ask a question