Need Help Sorting (using '03)

  • Thread starter Thread starter Nit_Wit_400
  • Start date Start date
N

Nit_Wit_400

I need to find a way to sort a spreadsheet (using '03) according to
book number and page number.

The book/page number is in the same column and is separated (usually)
by a "/"

Sometimes the book number is a letter or sometimes it has parentheses.

For example, the column has information including:

B/21
Pg. 32
24/164
D/45
2-Dec-47
89W-1
41-78-1049




Moral is, this column has very inconsistent data and I need to sort it
by book/page number

Any help?
 
Back
Top