Hi,

How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank? If cell "A1" is blank then it should not copy anything to cell "B1"?

I have hundreds of cells which is to be modified. The problem is some cells in column "A" are blank. In that case it should not copy anything to related cell in column "B" because most of column "B" cells also contain data.

Please help.

Hi Learner7,

The simplest way is to temporarily use another column, in which you put a formula like:
=IF(B1="",A1,B1)
and copy down as far as needed. You can then copy that column's result and paste it back into column B as 'values' (using Paste Special).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]