Jump to content

jjoh

Level 1
  • Posts

    1
  • Joined

  • Last visited

Posts posted by jjoh

  1. On 7/27/2019 at 6:11 AM, 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:

    Evernote-Excel error.jpg

    When you copy/paste into excel for sorting, there is a way to eliminate the merged cell problem:

    1. Copy/paste data into excel. After you paste, the pasted data should already be highlighted, or you can highlight the whole sheet or just the cells you want to sort. Either way, the merge & center button should light up indicating that there are merged cells in your selection.
    2. Click the merge & center button and it should unmerge the merged cells
    3. Highlight again as appropriate for your sorting needs and sort

    Worked for me. Hope it helps others as well.

    • Like 1
×
×
  • Create New...