Thread
:
Sorting or Filtering
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Sorting or Filtering
=len(trim(a2)) in a helper column
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"JD" wrote in message
...
Can someone please help me? I need to sort a column by the number of
digits...not the amount. Some numbers are 6 digits, 8 digits, and then 14
digits. I need to sort them by the number of digits and not the value.
Any
ideas?
Thanks
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett