How to sort (separate)...
 

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

How to sort (separate)...
 

Use a helper column with following formula:
=ISERROR(A1*1)

HTH
--
AP

"Mare" a écrit dans le
message de news: ...

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

How to sort (separate)...
 

Thank You,

elegant solution.


Ardus Petus Wrote:
Use a helper column with following formula:
=ISERROR(A1*1)

HTH
--
AP

"Mare" a écrit dans
le
message de news: ...

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



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