Hello,
I would like to know if there was a way in excel 2007 to sort a column of cells by their length/number of characters.
Any help would be greatly appreciated
Hello,
I would like to know if there was a way in excel 2007 to sort a column of cells by their length/number of characters.
Any help would be greatly appreciated
Last edited by vargs; 06-24-2010 at 04:32 PM.
Add a formula in a convenient column =len(A1) and sort on that.
Entia non sunt multiplicanda sine necessitate
thanks that works just fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks