If you can use AutoFilter, one of it's drop-down options is ""non-blanks)"

--
George Nicholson

Remove 'Junk' from return address.


"malik641" wrote in
message ...

Is this possible?
I want to filter a range but the range contains blank spaces.....is
there a way to have a filter that omits blank spaces?


--
malik641
------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=380120