software

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 quot;sortquot; is not sorting numeric on top and mixed
on the bottom.
Column is imported from .txt file and formated as quot;textquot;, because of
the leading zeroes.

Thank's in advance--
Mare
------------------------------------------------------------------------
Mare's Profile: www.excelforum.com/member.php...oamp;userid=27644
View this thread: www.excelforum.com/showthread...hreadid=542541Use a helper column with following formula:
=ISERROR(A1*1)

HTH
--
AP

quot;Marequot; gt; a écrit dans le
message de news: ...
gt;
gt; Hi all,
gt; I have column with 40000 rows, values in some of the cells are only
gt; numbers and in the rest are mixed (numbers and letters). Number of
gt; caracters in the cell varies from 6 to 10.
gt; I need is to sort (separate) rows with only numeric values.
gt; For some reason simple quot;sortquot; is not sorting numeric on top and mixed
gt; on the bottom.
gt; Column is imported from .txt file and formated as quot;textquot;, because of
gt; the leading zeroes.
gt;
gt; Thank's in advance
gt;
gt;
gt; --
gt; Mare
gt; ------------------------------------------------------------------------
gt; Mare's Profile:
gt; www.excelforum.com/member.php...oamp;userid=27644
gt; View this thread: www.excelforum.com/showthread...hreadid=542541
gt;

Thank You,

elegant solution.Ardus Petus Wrote:
gt; Use a helper column with following formula:
gt; =ISERROR(A1*1)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Marequot; gt; a écrit dans
gt; le
gt; message de news: ...
gt; gt;
gt; gt; Hi all,
gt; gt; I have column with 40000 rows, values in some of the cells are only
gt; gt; numbers and in the rest are mixed (numbers and letters). Number of
gt; gt; caracters in the cell varies from 6 to 10.
gt; gt; I need is to sort (separate) rows with only numeric values.
gt; gt; For some reason simple quot;sortquot; is not sorting numeric on top and
gt; mixed
gt; gt; on the bottom.
gt; gt; Column is imported from .txt file and formated as quot;textquot;, because of
gt; gt; the leading zeroes.
gt; gt;
gt; gt; Thank's in advance
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Mare
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Mare's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=27644
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=542541
gt; gt;--
Mare
------------------------------------------------------------------------
Mare's Profile: www.excelforum.com/member.php...oamp;userid=27644
View this thread: www.excelforum.com/showthread...hreadid=542541