In Excel 2003 for sorting the rows using the desired column use
Data/Sort option. However, you may end up with a problem of being able
to sort only files with less then 65,536 rows in Excel 2003. Newer
versions of Excel and OpenOffice have the extended limit of 1,048,576
rows. Even in that case you may want to analyze bigger files with more
than 1,048,576 rows.
One possible way to sort according
to the first column:
Install Notepad++,
http://notepad-plus-plus.org/
Click Plugins/Plugin Manager/Show Plugin Manager
Under Available find TextFx Characters
Click Install
Selext rows to be sorted.
Click TextFx/TextFx Tools
Check or uncheck Sort ascending
Click Sort lines case sensitive or Sort lines case insensitive
No comments:
Post a Comment