(Solved) – Remove Blanks in Excel using Formula

(solved)-–-remove-blanks-in-excel-using-formula

I have the below example where I have 3 columns in “CONDITION”

If I have data in all the 3 columns then the results should be column2 and column3 as shown in fig.

enter image description here

I used the below formula for “Results with my formula”

=IF(AND(NOT(ISBLANK($A2));NOT(ISBLANK( $B2));NOT(ISBLANK( $C2)));CONCATENATE( $B2; $C2)

But, I need the results as in “Expected Results” column

In case if the value in the above row is empty then the current value has to be posted in this cell.

Leave a Reply

Your email address will not be published. Required fields are marked *