Hello
I have tried searching on the issue, sorry if there is an easy answer!
However, my problem is that I have a semi large data sheet with approx. 20 coloumns and 3500 rows
My task is then to count the characters in each cell, for each coloumn and list up character lenghts of each cell from highest to lowest.
Is there a easy way to do this, or do I have to create a separate coloum for each and then use then LEN function and then put that new coloum in Pivot, which would take some time if this needed to be done for a lot more data.
Hope I have made my problem understandable, first time posting -
thanks in advance!
Cheers
I have tried searching on the issue, sorry if there is an easy answer!
However, my problem is that I have a semi large data sheet with approx. 20 coloumns and 3500 rows
My task is then to count the characters in each cell, for each coloumn and list up character lenghts of each cell from highest to lowest.
Is there a easy way to do this, or do I have to create a separate coloum for each and then use then LEN function and then put that new coloum in Pivot, which would take some time if this needed to be done for a lot more data.
Hope I have made my problem understandable, first time posting -
thanks in advance!
Cheers
