Thread: Need to sort based on the length of cells
View Single Post
 
Old 08-30-2021, 09:51 PM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
  
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default 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
Attached Files
File Type: xlsm Source1.xlsm (15.7 KB, 8 views)
Reply With Quote