Excel for mac soft return

broken image
broken image

However, when I import the data into Excel 2007, set the appropriate delimiter, and set the text qualifier to double quote, the line breaks are still creating new records at the line breaks, where I would expect to see the entire text field in a single cell. In order to counteract this, I have wrapped the field in double quotes ('). One of the fields is a free-text field, which may contain line breaks, commas, quotations, etc. I'm working on a feature to export search results to a CSV file to be opened in Excel.