Cannot sort field

's Computer Specifications

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

's Computer Specifications

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

lkw441 wrote:
>
> 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 field
> 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 be
> appreciated. Thanks.
>
> Larry
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson
(E-Mail Removed)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to sort (by one field), copy (based on one field) to another tab,then clear data on original sheet.	Mel	Microsoft Excel Programming	3	17th Apr 2009 09:18 PM
Sort Field or Not Sort Field	protean_being	Microsoft Access	2	9th Feb 2009 10:48 PM
REQ: Date field and automaticl Sort field fill - solutions, ideas	SeeAll	Microsoft Access Getting Started	4	27th May 2007 08:40 AM
Can I sort by field A but group by field B?	Michael Nagan	Microsoft Access Queries	3	15th Feb 2007 12:10 AM
DataView sort fails to sort on fields with comma in field names	Mone Hsieh	Microsoft ADO .NET	1	14th May 2004 09:29 PM