Cell Content Greater than 24 Characters.

D

dlnorris

I am needing to sort a column by cells that have greater than 24
characters. Is there a simple function to achieve this?

Thanks in advance.

-Donald
 
C

Cutter

If your data starts in A1 then in B1 type:

=IF(LEN(A1)>24,1,0)

Drag copy the formula down as far as necessary.

Now select the used range in the 2 columns and do a sort on it based on
the value in column B
 
Top