how to copy/paste data of a range only on empty cells of other equal range.

asked 2019-04-23 13:56:56 +0200

laurencio gravatar image

updated 2019-04-23 14:02:03 +0200

Hello. I have two columns A and B with data on some of their cells, and some other cells are empty, randomly. I need to paste data of column A over column B but only on empty cells of B (I don't want to override if there is data on cells of Column B). I mean, i want to paste only if the cell on column B is empty and if not just skip it. The purpose is to unify data of both columns given the fact that values of column B is preferable than data of columns A (except where cells of column B are empty, better A than nothing) On Paste Special dialog, I find the option "Skip empty cells", but I think I need just the opposite: "Skip full cells".

How can I do this selecting the full range of cells (they are too many to do it manually one by one)?

Hope you understand. Thanks a lot.

edit retag flag offensive close merge delete


I can only imagine column C formula =IF(B1<>"";B1;A1) and copy column C over B (values/text only), but there may be guys here having a smarter solution

Opaque gravatar imageOpaque ( 2019-04-23 14:04:20 +0200 )edit

Do it in an opposite way - copy B column over A via Paste Special dialogue with Skip empty cells option checked.

SM_Riga gravatar imageSM_Riga ( 2019-04-23 18:14:18 +0200 )edit

OMG - I'm getting old

Opaque gravatar imageOpaque ( 2019-04-23 18:53:04 +0200 )edit