Re: Sorting Numbers w/Aplha Suffix

Bryan,
your suggestion requires the cells to be modified.

After using Ken's suggestion, i.e. converting to text via =""&A1 then
copying and pasting as values, I am prompted with the following message when
I try to sort the data:
The following sort key may not sort as expected because it contains some
numbers formatted as text.
What would you like to do:
- Sort anything that looks like a number, as a number
- Sort numbers and numbers stored as text separately

Option 1 will give the result that MoonRay required.

"Bryan Hessey" wrote:

>
> Melissa,
>
> It appeared that the only way to stop the sort from determining that
> some cells were numbers was to put a ' single quote into the cell.
> This then allows 0006 to be followed by 0006A and 0007
>
>
> Melissa Wrote:
> > A post titled "Sorting Issue. Please help" on 14 Nov suggests several
> > ways to
> > answer your question. I personally think Ken Wright's 1st suggestion
> > is the
> > most straight-forward. Copied here for you:
> >
> > Convert everything to text. Assuming your data is in Col A, then in
> > Col B
> > use
> > =""&A2 and copy down. Then copy and paste special as values and delete
> > Col
> > A. Now sort on your data as you wish.
> >
> > Please note diff with Bryan's suggestion. Here, it's equal doubleQuote
> > doubleQuote ampersand A2
> > "Moonray80" wrote:
> >
> > > Is there any way to properly sort a series of numbers with an alpha
> > suffix?
> > > Example:
> > >
> > > 92001
> > > 92001A
> > > 92001B
> > > 91005
> > >
> > > I've tried to convert the numbers to text but the alpha suffix nubers
> > still
> > > end up in a separate group.
> > >
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
> View this thread: http://www.excelforum.com/showthread.php?threadid=486113
>
>
.

Relevant Pages

  • Re: Which is the worse fate
    ... I believe his office was 6,600 feet underground. ... He was some sort of SysAdmin for those folks doing the ... Bryan S. Slick, ...
    (rec.sport.football.college)
  • Re: Uh Oh!
    ... :>:I'm sorry, Bryan, but you're wrong. ... :> attitude is also exactly the sort of thing that creates terrorists. ... The overall attitude is what creates terrorists, ...
    (rec.sport.football.college)
  • Re: Insurance Assholes
    ... recognizing that the number of bills ... everyone gets the same sort of official correspondence who has a bill. ... Bryan S. Slick, ...
    (rec.sport.football.college)
  • Re: Pinball Circus MN
    ... No Bryan, you didn't ask me nicely to change anything. ... than your post it note response when I asked Jason a question." ... I look forward to the opportunity to sort things out with you. ... "the true colors of LTG?" ...
    (rec.games.pinball)
  • Re: Sorting Linked Data Between Sheets
    ... If I could name cells so the names continued ... information as to how to sort the source sheet while the linked refernces on ... the destination sheet (in another workbook) refer to same cell data on the ...
    (microsoft.public.excel.worksheet.functions)