hfeddema

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

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 some very long tables that I would like to sort alphabetically by the first column. Is there any way to do this?