sort by number of letters?

Hey,
I was wondering how i would sort a column by the number of letters? for
example:
Mark
Larry
Andrew
etc.

I'm kinda new to excel, so as much information would be appreciated

I'd use an adjacent column with a formula like:

=len(a1)

and drag down.

Then select all the range and data|sort by that helper column

Wicked Joe wrote:
>
> Hey,
> I was wondering how i would sort a column by the number of letters? for
> example:
> Mark
> Larry
> Andrew
> etc.
>
> I'm kinda new to excel, so as much information would be appreciated

--

Dave Peterson

great, worked well. thanks.

Dave Peterson wrote:
> I'd use an adjacent column with a formula like:
>
> =len(a1)
>
> and drag down.
>
> Then select all the range and data|sort by that helper column
>
> Wicked Joe wrote:
>
>>Hey,
>>I was wondering how i would sort a column by the number of letters? for
>>example:
>>Mark
>>Larry
>>Andrew
>>etc.
>>
>>I'm kinda new to excel, so as much information would be appreciated
>
>