also look for LEN


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JD" wrote in message
...
Can you please elaborate on that for me? I am only familiar with the
basics
of Excel.

"Don Guillett" wrote:

=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