You could use a filter and filter out blanks and zeros and then copy and
paste the result


--


Regards,


Peo Sjoblom


"Texas Aggie" wrote in message
...
Nick,

If you sort them and delete, how do you plan on getting them back to the
order in which they were in? Sorry, just curious.


--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"Nick Hodge" wrote:

If you want to permanently delete them, sort the data and delete all the
rows with '0'

If you want to hide them temporarily, check out DataFilterAutofilter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html



"ekkeindoha" wrote in message
...
Need to know a formula to remove blank cells or cells containing 0.
eg
A
21
0
33
44
0
What I'm looking for are
A
21
33
44
No zero or blank cells.

thx