RE: sort alphanumeric

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have the same problem as William, but your solution does not work on my
data. What other suggestions might you have?

"Sloth" wrote:

If you input a number and then change the format to text, the change does not
"set in" right away. I copied and pasted your list into excel and sorted to
get the result you got. I then changed the format to text and got the same
result. I then hit F2 and then enter for each cell in the list. At this
point it sorted correctly. On way to avoid this, is to use an ' (apostrophe)
before numbers that should be text. This formats it as text to begin with.

1227
1244
1257
1258-A
1258-B
1258-C
1258-D
1258-F
1258-G
1273-A
1273-B
1273-C
1273-D
1273-E
1273-F
1277
1289
1403-E
1403-G
1421
1422
1423
1431
1432
1438
1494
1572

"William" wrote:

I want to sort data that contains numbers and letters. I have tried
formatting the row as text and it still does not work. Everytime I sort it
doesn't list the entires in order but rather the numbers first then the
numbers with letters next. Here is what im trying to sort:

1227
1244
1257
1277
1289
1421
1422
1423
1431
1432
1438
1494
1572
1258-A
1258-B
1258-C
1258-D
1258-F
1258-G
1273-A
1273-B
1273-C
1273-D
1273-E
1273-F
1403-E
1403-G

Can anyone Help!

.

Relevant Pages

  • my controversial proposal wont honour before I feed it
    ... coherent classrooms. ... May doesn't William dislike simultaneously? ... colourful, I mean, supporting instead of resident fightings? ... No pathetic just path informs holdings sort of Toni's christian ...
    (sci.crypt)
  • Re: Completely baffled on what should be simple
    ... the same thing I previously did, changing format to custom ... sort, it didn't work. ... if a cell contains the text ...
    (microsoft.public.excel.misc)
  • Re: Completely baffled on what should be simple
    ... And remember just changing the format of the cell won't change the underlying ... sort, it didn't work. ... for the extensions that have either one or two 0's as the first numbers, ...
    (microsoft.public.excel.misc)
  • Re: Sane Syntax
    ... It's sort of like a game of telephone - if converting ... I don't know much about DocBook, but tsy's "Super DocBook" format does ... capability for visual markup, ... material before it was typeset. ...
    (comp.text.tex)
  • Re: Sort order - Data midified / Created
    ... What you suggest is a kludge to get around a Windows flaw. ... on the sub heading "Change the date, time, or number format" On the Formats ... All I do is click on the column header and the sort happens, ...
    (microsoft.public.windows.vista.general)