Excel question

[Guest Trish]

Hi All,

 

In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file

10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B

order?

 

Thanks for any replies.

 

Trish

[Guest Pegasus \(MVP\)]

Re: Excel question

 

 

"Trish" <Nobodyknowsabcdef@unknown.com> wrote in message

news:eaAW6CZjIHA.5280@TK2MSFTNGP02.phx.gbl...

> Hi All,

>

> In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file

> 10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B

> order?

>

> Thanks for any replies.

>

> Trish

 

I would post the question in an Excel newsgroup.

[Guest PD43]

Re: Excel question

 

"Trish" <Nobodyknowsabcdef@unknown.com> wrote:

>Hi All,

>

>In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file

>10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B

>order?

 

microsoft.public.excel.misc

[Guest PaulMaudib]

Re: Excel question

 

On Mon, 24 Mar 2008 13:10:49 +0400, "Trish"

<Nobodyknowsabcdef@unknown.com> wrote:

>Hi All,

>

>In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file

>10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B

>order?

>

>Thanks for any replies.

>

>Trish

>

Why ask HERE? Do you see Excel or OFFICE in this group's title?

 

Ask elsewhere

[Guest Nightowl]

Re: Excel question

 

Trish <Nobodyknowsabcdef@unknown.com> wrote on Mon, 24 Mar 2008:

>In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file

>10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B

>order?

 

Hi Trish

 

Do you mean 10A/B and 11A/B are sorting before 2A/B?

 

If so that's because they're a mixture of numbers and characters which

Excel treats as text. This article might help:

<URL:http://www.lockergnome.com/windows/2007/06/05/set-up-your-own-sort-o

rder-in-excel-2007/>

--

Nightowl

[Guest M.I.5¾]

Re: Excel question

 

 

"PaulMaudib" <none@none.net> wrote in message

news:kefgu3h1kq0hbpof1fk2or3kqofouehse2@4ax.com...

> On Mon, 24 Mar 2008 13:10:49 +0400, "Trish"

> <Nobodyknowsabcdef@unknown.com> wrote:

>

>>Hi All,

>>

>>In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file

>>10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B

>>order?

>>

>>Thanks for any replies.

>>

>>Trish

>>

> Why ask HERE? Do you see Excel or OFFICE in this group's title?

>

> Ask elsewhere

>

 

And once again you contribute nothing of value given that this was pointed

out in a far more helpful manner at least 14 hours earlier. And at least

that poster had the courtesy* to provide a suitable alternative newsgroup.

Something that you have never done.

 

*look it up as you are obviously unfamiliar with the concept.

[Guest PaulMaudib]

Re: Excel question

 

On Tue, 25 Mar 2008 10:35:25 -0000, "M.I.5¾"

<no.one@no.where.NO_SPAM.co.uk> wrote:

>

>"PaulMaudib" <none@none.net> wrote in message

>news:kefgu3h1kq0hbpof1fk2or3kqofouehse2@4ax.com...

>> On Mon, 24 Mar 2008 13:10:49 +0400, "Trish"

>> <Nobodyknowsabcdef@unknown.com> wrote:

>>

>>>Hi All,

>>>

>>>In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file

>>>10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B

>>>order?

>>>

>>>Thanks for any replies.

>>>

>>>Trish

>>>

>> Why ask HERE? Do you see Excel or OFFICE in this group's title?

>>

>> Ask elsewhere

>>

>

>And once again you contribute nothing of value given that this was pointed

>out in a far more helpful manner at least 14 hours earlier. And at least

>that poster had the courtesy* to provide a suitable alternative newsgroup.

>Something that you have never done.

>

>*look it up as you are obviously unfamiliar with the concept.

>

>

No, unlike others, I expect people to do their OWN research and

searching for appropriate groups. They learn more that way.

 

You should try it sometime, dip.

[Guest M.I.5¾]

Re: Excel question

 

 

"PaulMaudib" <none@none.net> wrote in message

news:9f0ju3tmhq2dl9d0gvgllpjja4c84bfh63@4ax.com...

> On Tue, 25 Mar 2008 10:35:25 -0000, "M.I.5¾"

> <no.one@no.where.NO_SPAM.co.uk> wrote:

>

>>

>>"PaulMaudib" <none@none.net> wrote in message

>>news:kefgu3h1kq0hbpof1fk2or3kqofouehse2@4ax.com...

>>> On Mon, 24 Mar 2008 13:10:49 +0400, "Trish"

>>> <Nobodyknowsabcdef@unknown.com> wrote:

>>>

>>>>Hi All,

>>>>

>>>>In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file

>>>>10A,10B,11A,11B sorts in this order. How to make sort in

>>>>1A,1B,2A,2B,3A,3B

>>>>order?

>>>>

>>>>Thanks for any replies.

>>>>

>>>>Trish

>>>>

>>> Why ask HERE? Do you see Excel or OFFICE in this group's title?

>>>

>>> Ask elsewhere

>>>

>>

>>And once again you contribute nothing of value given that this was pointed

>>out in a far more helpful manner at least 14 hours earlier. And at least

>>that poster had the courtesy* to provide a suitable alternative newsgroup.

>>Something that you have never done.

>>

>>*look it up as you are obviously unfamiliar with the concept.

>>

>>

> No, unlike others, I expect people to do their OWN research and

> searching for appropriate groups. They learn more that way.

>

 

If that attitude was universal, then there would be no place for newsgroups

or indeed any forum.