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.