paste special
 

Hi,
I have a column of data with 4 blanks cells between each data. I just want
to copy the data without any blank betwee.
I did a paste special and I choose skip the blank but it doesnt work
thanks
Ade

paste special
 

Give this a try... Select the range. Hit F5 (or Ctrl+G or Edit - goto).
Select Constants or Formulas (depending on the nature of what you are
copying). Only the populated cells should now be selected (assuming you do
not have formulas returning blanks). Hit Ctrl+C to copy and then paste the
cells in thir destination.
--
HTH...

Jim Thomlinson


"adeline" wrote:

Hi,
I have a column of data with 4 blanks cells between each data. I just want
to copy the data without any blank betwee.
I did a paste special and I choose skip the blank but it doesnt work
thanks
Ade

paste special
 

Thank you so much; it works
"adeline" wrote:

Hi,
I have a column of data with 4 blanks cells between each data. I just want
to copy the data without any blank betwee.
I did a paste special and I choose skip the blank but it doesnt work
thanks
Ade

paste special
 

Skip Blanks only prevents copied blank cells from overwriting existing data.

Not meant for deleting the blank cells when copying.

See Jim's reply for workarounds.

Why do you have the blank cells in the first place?

Maybe you could get rid of them at source?


Gord Dibben MS Excel MVP


On Wed, 30 Jan 2008 13:59:04 -0800, adeline
wrote:

Hi,
I have a column of data with 4 blanks cells between each data. I just want
to copy the data without any blank betwee.
I did a paste special and I choose skip the blank but it doesnt work
thanks
Ade