On Tue December 5 2006 01:37, + Amalia Elena wrote:
> [ MODERATED ] ***********************
> A friend suggested I try OpenOffice.org to be able to do a true alpha
> numeric sort that I am not able to do in Excel.
>
> I am not sure how to do that. Using the icons at the top of the
> browser window, I am not getting what I would like.
>
> I want A1 - A100 to sort that way rather than A13, A14, A2.
As you are not subscribed you may not have seen that:
On Tue December 5 2006 13:28, Claudia Drechsle wrote:
> Hi Amalia
>
> > I want A1 - A100 to sort that way rather than A13, A14, A2.
>
> I'm not sure if I understand. But if you get
> A1
> A12
> A100
> A2
> A23
> A3
>
> that IS a "true alpha numeric sort" and that is what I get in this example
>
> If you need a sort in a "numeric" sense:
> A1
> A2
> A3
> A12
> A23
> A100
>
> You have to split the column, f.e. like this:
>
> =LEFT(A1;1)
> and
> =VALUE(MID(A1;2;LEN(A1)))
>
> Then you use the both new columns (menu: data/sort) for the sort
Please reply to users@openoffice.org only.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
