SORT BY NUMBER OF CHARACTERS

D

Dsuperc

Board Regular
Joined
Apr 3, 2002
Messages
135
I need to sort a column by the number of characters in each cell.
I tried the "LEN" to find out the number of characters in each cell so that I could then do a sort,but for some strange reason that feature does not work.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
Where did the data come from? Its possible that each cell contains spaces to make them all the same length. Try doing an =trim() to each cell first?
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question
How to create a macro to sort 2 non-adjacent columns?
Replies
1
Views
137
helpneeded2
H
gheyman
  • Solved
Extracting a number for a cell
Replies
1
Views
261
dreid1011
dreid1011
S
  • Question
Too many characters in the cells of my Pivot Table?
Replies
0
Views
420
SorenN
S
B
  • Question
When is a number not a number? Match() does not recognize number.
Replies
7
Views
504
Tupe77
T
S
  • Question
VBA to ignore certain MAC Address values but process all others
Replies
1
Views
181
myall_blues
myall_blues

Forum statistics

Threads
1,214,649
Messages
6,120,732
Members
448,987
Latest member
marion_davis

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top