work around limit on # of rows

[shabnam]

I'm working on a dictionary with 145,000 words and want to
use Excel to sort them, but have run into an Excel limit
of about 65,000 rows. Is there any work-around that would
allow me to use all 145,000 words/rows at once?

Big thanks.

 

[Jim Cone]

shabnam,

The limit is 65536 rows per worksheet, cannot be changed.
You could split your list up over three worksheets: A:I, J:R, S:Z and sort them separately?

Regards,
Jim Cone
San Francisco, CA

 

[Guest]

sorting them separately is not useful to me for the
following reason: I want to sort them based on their type
and token frequencies (and do other various manipulations
of the data). This means that I need them all to be
together in order to be able to do this.

Thanks for replying.
-shabnam

-----Original Message-----
shabnam,

The limit is 65536 rows per worksheet, cannot be changed.
You could split your list up over three worksheets: A:I,

J:R, S:Z and sort them separately?

Regards,
Jim Cone
San Francisco, CA

"shabnam" <[email protected]> wrote in

message news:[email protected]...

 

[Dave Peterson]

There are other programs that can sort humungous amounts of data.

I use a text editor called UltraEdit (ultraedit.com) that has a sort built in.

If you search www.shareware.com, you'll find lots of programs that can do
it--some freeware.

But I'm not sure what you'd do next after your sort. That 65536 row limit can
be difficult to work around.