Sorting Value Ranges

[inspiresit]

I'm looking to sort a range in Excel but there is more than just a normal sort.

For example the data would look like

Value:
0-50
51-100
101-200
201-300

These ranges would be in any order in the sheet but I would need to sort them like above going from the smallest to the largest. Does this makes sense.

Any suggestions would be welcome

[day92]

No!

Upload some sample data with your expected results.

[ChemistB]

You'll need to set up a different column and sort them by that column. The formula in the other column (assuming your data starts in cell A1 would be
=LEFT(A1,FIND("-",A1)-1)+0
Would that work for you?

[inspiresit]

You'll need to set up a different column and sort them by that column. The formula in the other column (assuming your data starts in cell A1 would be
=LEFT(A1,FIND("-",A1)-1)+0
Would that work for you?

Thats worked. Thanks for that.

[inspiresit]

You'll need to set up a different column and sort them by that column. The formula in the other column (assuming your data starts in cell A1 would be
=LEFT(A1,FIND("-",A1)-1)+0
Would that work for you?

As I said in the previous post this worked and I was wondering how is this function working? What does "-" represent?

[shg]

It's the hyphen in the text string.