Help to Order by colum

pinkyuru

New member
Joined
Feb 14, 2012
Messages
1
Reaction score
0
Points
0
Hi! Ineed help to order by "X" colum with complicated data.

this colum have a text format. contains a book number and year like this "1542/02" book number 1542 from 2002.

how can do to order by year ? it's imposible ? i mean, first criteria must be year, later the book number.

maybe i have to change de cell format for a custom one, i try somes but get an error ..... and then the order data. uff, headake

thanks !!
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
What I would do is use another column to flip the data into the format that I need it. Assuming your data is in column A:
=right(A2,2)&"/"&left(A2,4)

If you run that down a column you should end up with your year first, and now it should sort by year then book.
 
Top