How to sort (separate)...

M

Mare

Hi all,
I have column with 40000+ rows, values in some of the cells are onl
numbers and in the rest are mixed (numbers and letters). Number o
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 mixe
on the bottom.
Column is imported from .txt file and formated as "text", because o
the leading zeroes.

Thank's in advanc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top