Help!

Excel-Sorting data alpha-numerically..kinda
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  How to fix a giant file that running slow?  
Author Message
mwoody1



Joined: Oct 31, 2007
Posts: 2
PostPosted: Wed Oct 31, 2007 3:12 pm    Post subject: Excel-Sorting data alpha-numerically..kinda
I need to sort over 1000 numbers in Excel but by the letter within the number..is it possible? Example...

I need this column...

1458-EE4-045
0332-PP1-567
0333-PP1-568
2325-CC4-089
3688-RR1-678

to be like this...

2325-CC4-089
1458-EE4-045
0332-PP1-567
0333-PP1-568
3688-RR1-678

Don't care about the numbers, just in order by the letters

Thanks!
Back to top
bwoody123



Joined: Apr 25, 2007
Posts: 11
PostPosted: Mon Nov 05, 2007 11:26 am    Post subject: Re: Excel-Sorting data alpha-numerically..kinda [Login to view extended thread Info.]
Assuming there is a title row, the data would begin in row 2.
I would suggest adding a new column with the formula
=MID(A2,(FIND("-",A2)+1),10)
Fill the formula down the column, then sort the sheet by that new column.

You could hide the column afterwards, or just delete it if you won't be adding rows later and need to resort.
Back to top
mwoody1



Joined: Oct 31, 2007
Posts: 2
PostPosted: Mon Nov 05, 2007 1:08 pm    Post subject: Re: Excel-Sorting data alpha-numerically..kinda [Login to view extended thread Info.]
Wow it worked that's awesome, thanks so much
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum