Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting last 5 characters from a cell | Excel Discussion (Misc queries) | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Counting spefic cell (not a range) with a value greater than 1 | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |