K
kojaks43
I recently learned how to avoid (blank) to be printed when the data cell is
blank in a merge.
I placed the If statement on the same line as the Address1 saying, if
Address2 was not blank to place Address2 data.
It works fine, except it places Address2 on the same line as Address1.
When I moved the If statement below Address1, it placed the data for
Address2 correctly. HOWEVER, when Address2 was a blank cell, it just left an
extra line between Address1 and City, State Zip.
Is there a way to eliminate the empty line?
k
blank in a merge.
I placed the If statement on the same line as the Address1 saying, if
Address2 was not blank to place Address2 data.
It works fine, except it places Address2 on the same line as Address1.
When I moved the If statement below Address1, it placed the data for
Address2 correctly. HOWEVER, when Address2 was a blank cell, it just left an
extra line between Address1 and City, State Zip.
Is there a way to eliminate the empty line?
k