I need to be able to move back and forth between Excel and Panorama. (I’d love to do the whole thing in Panorama but I have to have something that will work on an iMac, a MacBook Pro and iPhone and iPad.)
The Excel table includes a cell with text in it that includes returns. (typed in Excel with an Option-Return keystroke). After saving to CSV in Excel, the PanX command File>New Database From Text… command pulls the table into Panorama seamlessly. But after editing the file in PanX and exporting to CSV file, when I import that file, the resulting cells (that originally had returns in them) have some other character that Excel flags as a box with a question mark in it. I haven’t been able to identify the character nor can I copy it into a search/replace dialog in Excel. I’m just stuck.
Can anyone help me?