Forum Discussion
lucasconvert
Jun 19, 2020Copper Contributor
I can't sort my column according to the number of characters in the cell
I can't sort my column according to the number of characters in the cell.
Bennadeau
Jun 19, 2020Iron Contributor
Hi lucasconvert
How about this ...
Let's say the data you want to sort is in Column A, write this is column B
cell B1 =LEN(A1)
cell B2 =LEN(A2)
...
Then sort your table with column B
Ben