Jump to content
Sign in to follow this  
hfeddema

Sorting table columns

Recommended Posts

I have some very long tables that I would like to sort alphabetically by the first column.  Is there any way to do this?

Evernote long table.jpg

Share this post


Link to post
Is there any way to do this?

Not In Evernote, no.

You could try copy/pasting the table into a spreadsheet, sorting there, and then pasting over the original on in your note.

  • Like 1

Share this post


Link to post

I pasted the table into an Excel worksheet, and tried to sort it by the first column, but got this odd error message:

Evernote-Excel error.jpg

Share this post


Link to post
43 minutes ago, hfeddema said:

I pasted the table into an Excel worksheet, and tried to sort it by the first column, but got this odd error message:

I have no problem copying a simple table and sorting in a spreadsheet
Merged cells do cause a sorting problem

If you post an enex export of your note, we can test it further

  • Thanks 1

Share this post


Link to post

I didn't merge any cells -- just created a new worksheet and pasted the Evernote table into it.  But I looked closely at the table, and I saw that there was an extra row between two rows of text, which starts at column 3, so apparently somehow it got merged when pasting the table.  I tried sorting again, but got the same message, so I looked again, and found several more rows with merged cells, and fixed them, and then finally I was able to sort.  It worked, except for two unsorted rows at the top (no, they didn't have spaces in front of the words).  I retyped the content of those rows at the bottom, and deleted the two unsorted rows at the top, and then finally I was able to get the whole table sorted.  I deleted the original Evernote table, and pasted in the sorted one, so now I have a sorted table.  This whole process is quite time-consuming, so I think that I will just insert a row at the right place when adding new rows in future.

It would be a lot easier if there was a native sort in Evernote.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...