Can data be sorted by the length in a field
 

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?

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?

Can data be sorted by the length in a field
 

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.
--
Gary''s Student - gsnu200906


"NanAnn58" wrote:

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?

Can data be sorted by the length in a field
 

Add a helper column, with the formula =LEN(A2) and copied down.
Select your full ranmge of data, including all the rows & columns you want
including, and sort by the new helper column.
--
David Biddulph

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

Can data be sorted by the length in a field
 

Thanks, worked perfectly.

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200906


"NanAnn58" wrote:

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?