Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
yasmingeo
 
Posts: n/a
Default How do I sort in Excel by the no. of characters in a cell?

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
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default How do I sort in Excel by the no. of characters in a cell?

On Thu, 20 Oct 2005 18:42:01 -0700, yasmingeo
wrote:

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


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
  #3   Report Post  
yasmingeo
 
Posts: n/a
Default How do I sort in Excel by the no. of characters in a cell?

Thanks Ron, perfect, and so easy.
Much appreciated,
Yasmin

"Ron Rosenfeld" wrote:

On Thu, 20 Oct 2005 18:42:01 -0700, yasmingeo
wrote:

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


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

  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default How do I sort in Excel by the no. of characters in a cell?

On Thu, 20 Oct 2005 20:58:02 -0700, yasmingeo
wrote:

Thanks Ron, perfect, and so easy.
Much appreciated,
Yasmin


You're welcome. Glad to help.
--ron
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should let me sort on cell background color mama Setting up and Configuration of Excel 5 July 5th 06 01:40 PM
Number of characters in a cell (one row, merged columns) Dajana Excel Discussion (Misc queries) 1 September 19th 05 09:30 PM
remove last three characters of cell mira Excel Discussion (Misc queries) 8 July 28th 05 12:06 AM
Sort Ascending button - Excel 2003 bigwheel Excel Discussion (Misc queries) 1 May 23rd 05 11:10 PM
how many characters i can put into one cell in Excel Gary Excel Discussion (Misc queries) 2 May 18th 05 02:08 PM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"