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?
|