Excel 2002: How to avoid pasting blanks ?

G

Guest

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
 
G

Guest

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
Excel 2002 : Problem in moving along blank cells 10
Excel 2002: How to restore the lost grid lines ? 1
Excel 2002: How to get the first and last reference in a column ? 7
Excel 2002: How to add content to a cell ? 4
Excel 2002 : How to remove trailing spaces ? 4
Excel 2002 : How to highlight picture with colors ? 2
Excel 2002 : How to move to the next cell with content ? 2

Top