Insert a blank column next to your data, and enter a formula like

=LEFT(A1,FIND(" ",A1)-1)

Then, sort by this new column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Smohrman" wrote in message
...
I'll probably slap myself when someone shows me how to do this,
but I'm
stuck...

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?

Thanks in advance :-D