Excel 2002: How to avoid pasting blanks ?
 

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


--
A36B58K641

Excel 2002: How to avoid pasting blanks ?
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote:
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


--
A36B58K641

Excel 2002: How to avoid pasting blanks ?
 

Hello Max,

Thanks for your help.

Best Regards

Low

--
A36B58K641


"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote:
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


--
A36B58K641

Excel 2002: How to avoid pasting blanks ?
 

welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote in message
...
Hello Max,

Thanks for your help.

Best Regards

Low