Sorting hyphenated numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you sort a list of hyphenated and non-hyphenated numbers so that
2079-1 comes before 2121?

Connie Martin
 
Try sorting the list on an adjacent helper col

Assuming the list is in col A, A1 down

Put in B1: =TEXT(A1,"@")
Copy down

Then sort both cols A and B by col B > Ascending

This should return the results ..
 
Thank you. That works. I put the column outside the print area. I was
hoping there would be a list one could create and then sort by it, but I
guess not.

Thanks again
Connie Martin
 
Hi Max

Have been reading your replies to the question from Connie which has been
great so far - but I have hit a brick wall. I am using hyphenated and unique
numbering which I have sorted into the order I want (see below), used your
additional column and added =TEXT(C2,"@").
What I want to do now is create a macro so that on the press of a button I
can have the whole sheet auto sort (which with usual numbering works really
well) ie new entry entered hit CTRL o and everything auto sorts. But in this
case data already in teh sheet stays in the order I manually entered BUT new
new entries remain at the bottom and don't update - do you know what I'm
missing please?
07074
07075
07076
07076-01
07076-02
07C08-001
07C08-002
 
Back
Top