Cell Content Greater than 24 Characters.

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

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

Thank you for the quick response, worked like a charm.

Happy times.

Thank You.

You're welcome. Glad it helped and thanks for acknowledging.