How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?

Learner7 · #1 04-25-2011, 03:38 AM

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.

macropod · #2 04-25-2011, 04:39 AM

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).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wierd symbols inplace of "space", "indentation" etc	aka.bhagvanji	Word	5	02-16-2012 11:50 AM
How to add a "note" which is "active" when doing a powerpoint show	Anders	PowerPoint	0	01-22-2011 08:47 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM
How do I change the "and" to "or" with multiple Rules (and Alerts)?	bschimmel	Outlook	0	11-16-2009 05:26 AM
Excel error: "Too many different cell formats"	enviroko	Excel	0	01-09-2008 07:27 AM