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

		Microsoft Office Forums > Microsoft Excel > Excel
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?

FAQ

Thread Tools

Display Modes

04-25-2011, 04:39 AM

macropod

Windows 7 32bit How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,375

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]

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:07 PM.