Thread: Skipping blanks
View Single Post
  #2   Report Post  
Ian
 
Posts: n/a
Default

Skip blanks does not remove the blanks. It just means that if you paste over
existing data, the blanks will not overwrite the existing cells.

--
Ian
--
"jmkona" wrote in message
...
When I try to copy data and paste it without the blanks in between, I use
the
paste special and check on the "skip blanks" box. However it does not
work.
Does anyone know how to accomplish this, or why it is not working?