Need to sort based on the length of cells
Hi Guys
I need to sort data in column A ranges A2:end of value based on their length using excel macro.
I have attached my file to sort column A.
Can anyone help out on this?
I have used this function but i need to add this as macro: SORTBY(A2:A36,LEN(A2:A36),-1)
thanks
|