Sort alphanumerically (updated)

I'm using Excel Mac 2011 first off. I've uploaded the file.

I put this text into a separate excel document but I'm basically taking all of this information and inserting it into another excel document and sorting alphabetically. I have no problem doing so except with this list. It's for my sports card collection and the card number is 52 and then it breaks off into a sub category. If you take the information and sort like I would typically it puts it into a list like this (see below) instead of (see below). Please help! Also if you're explaining it to me can you please make sure the equation is simplified I'm a novice.

I also lost grid lines on another sheet I have, how do I get them back? I'm aware of the 'gridlines' option however it doesn't make them reappear. Thanks for the help!sheffield moments and milestones.xlsx


This is the list that I'm importing the information from "moment and milestones" into. I'm inserting it in the end of row A. I highlight the last selection of R all the way up to A 2 and then sort on value. It's worked fine until now. I have been trying things, I just tried the delimiter however I couldn't get it to sort still. I managed to make another row in order however it wouldn't sort on that. Thanks
Sheffield Collection.xlsx


Incorrect
2008 Topps Moments and Milestones #52-1
2008 Topps Moments and Milestones #52-10
2008 Topps Moments and Milestones #52-100
2008 Topps Moments and Milestones #52-101
2008 Topps Moments and Milestones #52-102
2008 Topps Moments and Milestones #52-103
2008 Topps Moments and Milestones #52-104
2008 Topps Moments and Milestones #52-105
2008 Topps Moments and Milestones #52-106
2008 Topps Moments and Milestones #52-107
2008 Topps Moments and Milestones #52-108
2008 Topps Moments and Milestones #52-109
2008 Topps Moments and Milestones #52-11
2008 Topps Moments and Milestones #52-110
2008 Topps Moments and Milestones #52-111
2008 Topps Moments and Milestones #52-112
2008 Topps Moments and Milestones #52-113
2008 Topps Moments and Milestones #52-114
2008 Topps Moments and Milestones #52-115
2008 Topps Moments and Milestones #52-116
2008 Topps Moments and Milestones #52-117
2008 Topps Moments and Milestones #52-118
2008 Topps Moments and Milestones #52-119
2008 Topps Moments and Milestones #52-12
2008 Topps Moments and Milestones #52-120
2008 Topps Moments and Milestones #52-121
2008 Topps Moments and Milestones #52-122
2008 Topps Moments and Milestones #52-123
2008 Topps Moments and Milestones #52-124
2008 Topps Moments and Milestones #52-125


Correct
2008 Topps Moments and Milestones #52-2
2008 Topps Moments and Milestones #52-3
2008 Topps Moments and Milestones #52-4
2008 Topps Moments and Milestones #52-5
2008 Topps Moments and Milestones #52-6
2008 Topps Moments and Milestones #52-7
2008 Topps Moments and Milestones #52-8
2008 Topps Moments and Milestones #52-9
2008 Topps Moments and Milestones #52-10
2008 Topps Moments and Milestones #52-11
2008 Topps Moments and Milestones #52-12
2008 Topps Moments and Milestones #52-13
2008 Topps Moments and Milestones #52-14
2008 Topps Moments and Milestones #52-15
2008 Topps Moments and Milestones #52-16
2008 Topps Moments and Milestones #52-17
2008 Topps Moments and Milestones #52-18
2008 Topps Moments and Milestones #52-19
2008 Topps Moments and Milestones #52-20
2008 Topps Moments and Milestones #52-21
2008 Topps Moments and Milestones #52-22
2008 Topps Moments and Milestones #52-23
2008 Topps Moments and Milestones #52-24
2008 Topps Moments and Milestones #52-25
2008 Topps Moments and Milestones #52-26
2008 Topps Moments and Milestones #52-27
2008 Topps Moments and Milestones #52-28
2008 Topps Moments and Milestones #52-29
2008 Topps Moments and Milestones #52-30
2008 Topps Moments and Milestones #52-31