RE: Sorting alphanumeric

Thank you very much for your help. It's almost working. I neglected to say
that there was text in column two, but I just moved all of the formulas over
one column, assuming that would work. ( I entered the formulas and then
sorted by columns, C, D, E). The results I got were that the number 17' in
column one came out at the top of the list, even before the number 1. The
other "'" came out after the regular numbers. Thanks for any help you can
provide.

"Joanne" wrote:

> I would like to sort some text which is formatted in column one as:
> 1'
> 100
> 1000'
> 2
> 2'
> and so on. Any number that does not have an "'" at the end should come
> before any number that does and all the 1s, 2s, 3s, etc. should be grouped
> together. Is this possible? The result would look like:
> 1
> 100
> 1000'
> 2
> 2'
>
> Boy, would I appreciate some help.
.

Relevant Pages

  • Re: Is there any real rpg left out there ?
    ... Michael Vondung wrote: ... > If you'd rather get killfilled, that can be arranged, but you're sort of a ... > regular. ... Prev by Date: ...
    (comp.sys.ibm.pc.games.rpg)
  • Re: RR
    ... wouldn't presume to consider myself either regular or respected. ... Dr. Aman is probably in a category with Young Kira and Young Bob. ... are people who have paid their dues in the real world, but are too busy to ... Sort Of Respected Sort Of ...
    (alt.usage.english)
  • Re: URLS
    ... couple of dozen or so people who drink there on a regular basis.. ... predominance of smokers, or a predominance of people who don't care ... let's try and put things into your sort of ...
    (uk.rec.sheds)
  • Re: BBC2 - chinese food made easy
    ... For anybody else who doesnt really do this sort of thing on a regular ... basis - then the show itself was as useful as a slide rule is to forrest ...
    (uk.media.tv.misc)
  • Re: Speed limit crackdown to cut emissions
    ... I'm notoriously dim at this sort of thing. ... >> worked out who wip is but I have not got a clue about lushhead or ... >> veritable rosbif. ... > regular, when he came back. ...
    (uk.rec.motorcycles)