Can data be sorted by the length in a field

  • Thread starter Thread starter NanAnn58
  • Start date Start date
N

NanAnn58

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?
 
NanAnn58 said:
I am trying to sort the original description field that I dumped into
excel by the length of the field. Is this possible?
Click to expand...

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 -----
 
Use a helper column. Say the text data is in column A. In B1 entrer:
=LEN(A1) and copy down. Then sort cols A & B by B.
 
Thanks, worked perfectly.

Gary''s Student said:
Use a helper column. Say the text data is in column A. In B1 entrer:
=LEN(A1) and copy down. Then sort cols A & B by B.
Click to expand...
 
Back
Top