Sorting by diff. formats

  • Thread starter Thread starter eepico
  • Start date Start date
E

eepico

Hello,

Is there any way that I can sort 3 columns which using differen
numbering format, e.g. Column A by Absolute Value (containing letters
numbers and decimal), then Column B by Default, then Column C b
Absolute Value again?

So that I can sort the LC call number in my library...
A|B|C
BX1150|.D567|v.10
BX950|.D56|v.9
The correct order I need is: BX950 < BX1150, .D56 < .D567, v.9 < v.10

Thanks,
Jac
 
If your values were entered like:
BX0950

Then it would be a lot easier.

If you can't change the values in the cells, maybe you could use a helper cell
that shows the "nicer" value:

If column A is always 2 alpha followed by a bunch of numbers:

=left(a1,2)&text(--mid(a1,3,255),"0000")

Depending on your data, maybe you could use Data|Text to columns to separate
each "component" into its own cell.

When you extract 950 from that cell, you can choose general and it'll be the
numeric value of 950. Then you could either rebuild your values using a formula
a lot like the one above) or just sort by those helper columns.
 
Back
Top