Cannot sort field

[lkw441]

I have a field named CPU which will have 166Mhz, 200Mhz, 700MHz.....etc
I had to copy these fields over from another .xls Therefore the fiel
will say LEFT(sheet1!a1,18) even though it will display 166Mhz....etc.
I am trying to sort all of this but will not. Any help would b
appreciated. Thanks.

Larr

 

[Dave Peterson]

Can you convert to values first? Or maybe sort the original list.