Sorting Help

[Thrasher]

Hello Everyone,

I'm used to using the Sort function on the new excel but I have run into a new problem. My list starts with text and then has numbers in it, I am to sort the list by the numbers and ignore the text. My current list has items such as:

Gym 1.101
Gym 1.102
Gym 2.101
Gym 2.102
Gym10.101
Gym10.102

When I sort, the Gym10.101 goes in front on Gym 2.101 to look like:

Gym 1.101
Gym 1.102
Gym10.101
Gym10.102
Gym 2.101
Gym 2.102

This is just a sample of the problem but you get the idea, I want the item with the smaller number to come first, basically I need excel to ignore the letters and use just the numbers in the list to sort. Any ideas? Thank You

[roki4]

Have you tried Data > Filter > Autofilter at the top of the list you want sorted? From the drop-down menu in the cell sort by ascending. This puts it in the order you require for me.

[Russell Dawson]

Hi Thrasher,

Are you able to introduce a helper column and input this:

=MID(A1,4,2)

Then sort by that column. You are lucky that the text entry has a space after Gym if it is just one digit.

Cheers

Russell

[Thrasher]

ok, roki, I'm not sure what your asking me to do but when I tell it to sort it puts the GYM10.101 before GYM2.101 which is what im trying to fix. Russell, turns out there is not a space between the letters and the numbers, what now?

[roki4]

Instead of doing Data > Sort, do Data > Filter > Autofilter.

Here is a sample sheet with the autofilter and drop-down menu. Please let me know if you require anything else. Cheers.

[Russell Dawson]

Thresher,

If you haven't got your solution yet it's probably best if you could upload a representative sample workbook containing your data in its original format.

Russell

[roki4]

Ok, I see. If no space between letters and numbers then AutoFilter will not work either.