Null cell to be filled with different cell

[Cghizdav07]

I have two columns. Column A has some cells with blanks/null and most of the cells are populated. But in Column B i have cells which i would like to be moved/copied to null cells from Column A.

I was trying with IF formula, but i don`t know how to do it.

Can someone help?

Thanks!

[Sebastiaandb · Accepted solution]

Hi @Cghizdav07 ,

Try IF IsNull([COLUMNA]) OR IsEmpty([COLUMNA]) THEN [COLUMNB] ELSE [COLUMNA] ENDIF

Greetings,

Seb

[Cghizdav07]

Thank you Seb! it works!