"Smohrman" wrote:
I've got a series of values in a column as follows:
10 Mb
10 Mb
1000 Mb
1000 Mb
114 Mb
128 Mb
128 Mb
Obviously 1000 mb is more than 10 mb, but it sorts as second in the list
because it starts with a "1". How do I tell Excel to sort by the entire
numerical value instead of the first number?
Assume data in A1 down
Put in B1: =SUBSTITUTE(A1,"Mb","")+0
Copy down
Then sort both cols A & B by col B
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---