View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Can data be sorted by the length in a field

"NanAnn58" wrote:
I am trying to sort the original description field that I dumped into
excel by the length of the field. Is this possible?


Depends on your constraints. I would create a parallel column or row of
helper cells, fill it with =LEN(A1) etc, then sort the pair of columns or
rows by the helper cells.

Alternatively, you could write a macro.


----- original message -----

"NanAnn58" wrote in message
...
Swithching to a new computer system at work and the current description
field
has 35 characters and the new description field only has 30. I am trying
to
sort the original description field that I dumped into excel by the length
of
the field. Is this possible?