How to sort column...
 

Hi all
how can I sort column based on number of caracters in the cell.
Column is formated as text, values in cells are just numbers and
numbers and letters respectfully, number of caracters varies from 6 to
10, some of the cells in column have leading zeroes. I need to separate
all the cells which have 6 caracters(including leading zeroes).
I hope that explanation of my problem is clear.

Thanks in advance


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

How to sort column...
 

Use a helper column with following formula:
Assuming your data is in column A:
=LEN(A1)=6
then copy down
and sort on that new column.

HTH
--
AP

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

Hi all
how can I sort column based on number of caracters in the cell.
Column is formated as text, values in cells are just numbers and
numbers and letters respectfully, number of caracters varies from 6 to
10, some of the cells in column have leading zeroes. I need to separate
all the cells which have 6 caracters(including leading zeroes).
I hope that explanation of my problem is clear.

Thanks in advance


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

How to sort column...
 

Thank you, for the fast solution.
Your solution for my problem was embarrasingly simple, thanks for your
patience with "us". Hopefully one day........


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