Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells

I think you misunderstand the purpose of "skip blanks".

Skip Blanks option will still copy the blanks, the blanks just won't overwrite
existing data if copied onto a range containing data.

See help on "skip blanks".


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 04:25:02 -0800, "arudra1974"
wrote:

Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells

Thanks for clarifying.

But I have a huge dump of data in excel from an ERP which contains blank
cells in between. I cannot work on it until I remove the blanks. Is there any
way to remove the blanks apart from individually selecting the blanks and
deleting them?

Help is much appreciated.

"Gord Dibben" wrote:

I think you misunderstand the purpose of "skip blanks".

Skip Blanks option will still copy the blanks, the blanks just won't overwrite
existing data if copied onto a range containing data.

See help on "skip blanks".


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 04:25:02 -0800, "arudra1974"
wrote:

Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells

Audra

Select the range then F5SpecialBlanks and OK.

With blanks selected, EditDelete. You will get 4 options. Choose which one
you want.

Shift Up or Entire Row would seem to be the choices but I can't see the data
so don't know.


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 23:37:02 -0800, "arudra1974"
wrote:

Thanks for clarifying.

But I have a huge dump of data in excel from an ERP which contains blank
cells in between. I cannot work on it until I remove the blanks. Is there any
way to remove the blanks apart from individually selecting the blanks and
deleting them?

Help is much appreciated.

"Gord Dibben" wrote:

I think you misunderstand the purpose of "skip blanks".

Skip Blanks option will still copy the blanks, the blanks just won't overwrite
existing data if copied onto a range containing data.

See help on "skip blanks".


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 04:25:02 -0800, "arudra1974"
wrote:

Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells

Thanks Gord...It really did my work...Thanks a lot!!

"Gord Dibben" wrote:

Audra

Select the range then F5SpecialBlanks and OK.

With blanks selected, EditDelete. You will get 4 options. Choose which one
you want.

Shift Up or Entire Row would seem to be the choices but I can't see the data
so don't know.


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 23:37:02 -0800, "arudra1974"
wrote:

Thanks for clarifying.

But I have a huge dump of data in excel from an ERP which contains blank
cells in between. I cannot work on it until I remove the blanks. Is there any
way to remove the blanks apart from individually selecting the blanks and
deleting them?

Help is much appreciated.

"Gord Dibben" wrote:

I think you misunderstand the purpose of "skip blanks".

Skip Blanks option will still copy the blanks, the blanks just won't overwrite
existing data if copied onto a range containing data.

See help on "skip blanks".


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 04:25:02 -0800, "arudra1974"
wrote:

Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells

Thanks for the feedback.

Gord

On Sun, 20 Feb 2005 20:57:01 -0800, "arudra1974"
wrote:

Thanks Gord...It really did my work...Thanks a lot!!

"Gord Dibben" wrote:

Audra

Select the range then F5SpecialBlanks and OK.

With blanks selected, EditDelete. You will get 4 options. Choose which one
you want.

Shift Up or Entire Row would seem to be the choices but I can't see the data
so don't know.


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 23:37:02 -0800, "arudra1974"
wrote:

Thanks for clarifying.

But I have a huge dump of data in excel from an ERP which contains blank
cells in between. I cannot work on it until I remove the blanks. Is there any
way to remove the blanks apart from individually selecting the blanks and
deleting them?

Help is much appreciated.

"Gord Dibben" wrote:

I think you misunderstand the purpose of "skip blanks".

Skip Blanks option will still copy the blanks, the blanks just won't overwrite
existing data if copied onto a range containing data.

See help on "skip blanks".


Gord Dibben Excel MVP

On Sat, 19 Feb 2005 04:25:02 -0800, "arudra1974"
wrote:

Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells