Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() Quote:
Sub SortByLength() Range("A:A").EntireColumn.Insert With Range("B2", Cells(Rows.Count, "B").End(xlUp)).Offset(0, -1) .FormulaR1C1 = "=LEN(RC[1])" .Value = .Value End With Range("A2", Cells(Rows.Count, "B").End(xlUp)).Sort _ Key1:=Range("B2"), Order1:=xlDescending, Header:=xlYes Range("A:A").EntireColumn.Delete End Sub
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting characters, ignoring numbers | Excel Worksheet Functions | |||
Sorting Columns by number of characters | Excel Discussion (Misc queries) | |||
Sorting on only certain characters in a cell | Excel Worksheet Functions | |||
Ignoring characters when sorting | Excel Discussion (Misc queries) | |||
Sorting by Number of Characters | Excel Discussion (Misc queries) |