Ignore Blank Cells When Creating A Formula

[promoe]

Below is a journal voucher. I would like to extract the data to post in our DMS. I run into a problem when there are blank cells. I want to be able to go from left (debit entry) to right (credit entry). I initially wrote this two part formula:

The debit formula:
The first cell has to be by itself. So, in cell A50 I posted =A3
In B50 I posted =$A$49&""&B3*100&""&$A$49&""&C3&""&$A$49&""&D3
$A$49 is \r which acts as the enter button in the DMS.

The credit formula:
A51=F3
B51=$A$49&""&H3*-100&""&$A$49&""&I3&""&$A$49&""&E3

This works fine until I reach I5 (blank cell). I want to be able to keep the entries together versus posting the data from A3:D39 & then E3:I39

[TABLE="width: 960"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Any help is greatly appreciated.

Thank you

 

[Chrisdontm]

You could try something like this:

=IF($A$49="","--",$A$49)&" "&IF(B3="","--",B3*100)&" "&IF($A$49="","--",$A$49)&IF(C3="","--",C3)&" "&IF($A$49="","--",$A$49)&IF(D3="","--",D3)

Adjust as needed...