Hi all,
I have column with 40000+ rows, values in some of the cells are only
numbers and in the rest are mixed (numbers and letters). Number of
caracters in the cell varies from 6 to 10.
I need is to sort (separate) rows with only numeric values.
For some reason simple "sort" is not sorting numeric on top and mixed
on the bottom.
Column is imported from .txt file and formated as "text", because of
the leading zeroes.

Thank's in advance


--
Mare
------------------------------------------------------------------------
Mare's Profile: http://www.excelforum.com/member.php...o&userid=27644
View this thread: http://www.excelforum.com/showthread...hreadid=542541