Thread: [Solved] How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?
View Single Post
 
Old 04-25-2011, 04:39 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote