Technical Solution

How to append data from one column to another if some of the cells in first column is blank in OpenOfficeCalc?

Anju.r | | 1 min read

Suppose you are working in OpenOffice Calc. Your requirement is to copy the Column B value into Column A, if Column A is blank. If the columns have lots of cells, filling it manually is extremely tedious. So, read on to know how to do it.

We can use the Openoffice function ISBLANK() anf IF().

The syntax for the IF function is:


=IF( condition, [value_if_true], [value_if_false] ).

The syntax for the ISBLANK function is


= ISBLANK( Value )

Value: (required) - refers to the value or cell that is being tested

These two functions can be used to automate the job. So, we will apply the function as


=IF(ISBLANK(A1),B1,A1)

This will append the Col B value into Column A, if column A is empty. Otherwise, it will retain the value. Double clicking on the right end of the cell will append values in all the cells of column A.

Hope this function helps you do your job really fast.

 

 

Related Topics