How do I sort in Excel by the no. of characters in a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have some alpha-numeric codes which I need to order in terms of how long
they are in characters. Ie. a 15-character code corresponds to a certain
item, so I would like them all grouped together.

Thanks,
Yasmin
 
Hi there,

I have some alpha-numeric codes which I need to order in terms of how long
they are in characters. Ie. a 15-character code corresponds to a certain
item, so I would like them all grouped together.

Thanks,
Yasmin
Click to expand...

If your codes are in B2:Bn, in an adjacent column enter the formula =LEN(B2)
and copy/drag down to row n. Then sort on this "helper" column.


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Find the UPPERCASE letter in a string 9
Characters in cell. 1
Is it possible to count the no. of characters in a cell in Excel? 2
Adding the total # of characters in multiple cells 3
How to extract specific text from a string of characters 6
Parsing a alpha character out of a cell 7
Extracting certain characters from a long string 4

Back
Top