Skipping Blanks
 

I want to copy and paste 2 columns of numbers as follows:

A B
1 100
2 50
3 40
4
5 65
6 20 20
7
8 9
9 15
10

In my PASTED TO cells, I want all BLANKS to dissappear.

In other words, the new columns of numbers will not contain any blank cells.

How can I accomplish this please?

Thanks,

FLKulchar

Skipping Blanks
 

You have answers elsewhere - please do not multi-post.

Pete

On Mar 7, 7:33*am, F. Lawrence Kulchar
wrote:
I want to copy and paste 2 columns of numbers as follows:

* * * * * * *A * * * * * * * * * B
* 1 * * * *100 * * * * * * *
* 2 * * * * *50
* 3 * * * * * * * * * * * * * * *40
* 4 * * * *
* 5 * * * * * * * * * * * * * * *65
* 6 * * * * *20 * * * * * * * * 20
* 7
* 8 * * * * * * * * * * * * * * * *9
* 9 * * * * *15
*10 * * * * * * * * * * * * * * *

In my PASTED TO cells, I want all BLANKS to dissappear.

In other words, the new columns of numbers will not contain any blank cells.

How can I accomplish this please?

Thanks,

FLKulchar