Cell Content Greater than 24 Characters.

  • Thread starter Thread starter dlnorris
  • Start date Start date
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
 
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 must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup character limitations 1
Greater Than 24 But Less Than 48 - If Statement 4
Excel Conditioning Formatting 3
Excel Need Countifs Formula Help 0
Conditional Formatting based on 2 criteria 4
Conditional formatting based on character count 1
Vlookup Help 4
Minimum Date Greater than Today() 6

Back
Top