Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should let me sort on cell background color | Setting up and Configuration of Excel | |||
Number of characters in a cell (one row, merged columns) | Excel Discussion (Misc queries) | |||
remove last three characters of cell | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
how many characters i can put into one cell in Excel | Excel Discussion (Misc queries) |