View Single Post
  #2   Report Post  
Cutter
 
Posts: n/a
Default


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