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


--
dlnorris
------------------------------------------------------------------------
dlnorris's Profile: http://www.excelforum.com/member.php...o&userid=28081
View this thread: http://www.excelforum.com/showthread...hreadid=475868

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=475868

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

Happy times.

Thank You.


--
dlnorris
------------------------------------------------------------------------
dlnorris's Profile: http://www.excelforum.com/member.php...o&userid=28081
View this thread: http://www.excelforum.com/showthread...hreadid=475868

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=475868