View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Sort more then 65,000 rows in Excel

Other than upgrading to Office 2007, there's not much you can do in Exel.

If your file source is a delimited file you could bring it into MS Word,
convert the data to a table using your delimiter as a column break and the
sort the table.


--
Kevin Backmann


"Jeff" wrote:

Hi,

I am using Excel 2003 and it is limited to 65,000 rows. I want to sort a
.csv file that has ~ 360,000 rows. I tried using the Bubble sort macro to do
this but it is too slow. Is there any way to do this using excel?

Thanks