Excel 2002: How to avoid pasting blanks ?

M

Mr. Low

Dear Sir,

I have the following worksheet:

A B C
235 235
211 211
148 148
412 412
741 741
225 225
622 622


I wish to copy and pasting column A and B to column C simultaneously.

May I know the keyboard steps for avoiding pasting blank cells in column C ?

I try > Paste Special > Skip Blank but it still pasting bank cells by
overwriting earlier the cell content.


Thanks

Low
 
M

Max

Maybe using a formula might suffice?

Assuming source data in cols A and B as posted in A1:B7

Put in C1:
=IF(A1="",B1,A1)
Copy down to return required results.

If needed, select col C and kill the formulas
with an "in-place" copy n paste special as values
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002 : How to avoid pasting incremental refrences ? 3
Macro that sorts data with blanks at the bottom 1
How to pull in data from rows and columns if there are blanks? 0
Excel 2003 - Skip a cell 5
Excel 2002: Can I not overwriting non blank destination cells ? 0
Excel 2002 : Problem in moving along blank cells 10
Excel 2002: How to restore the lost grid lines ? 1
Copy named range, but skip blanks 1

Top