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

[yasmingeo]

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

[Ron Rosenfeld]

On Thu, 20 Oct 2005 18:42:01 -0700, yasmingeo
<[email protected]> 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

[yasmingeo]

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

"Ron Rosenfeld" wrote:

> On Thu, 20 Oct 2005 18:42:01 -0700, yasmingeo
> <[email protected]> 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
>

[Ron Rosenfeld]

On Thu, 20 Oct 2005 20:58:02 -0700, yasmingeo
<[email protected]> wrote:

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

You're welcome. Glad to help.
--ron