Excel for mac escape single quotes in csv

Question 1, Question2, Question3 (paragraph break)ДЄnswer 1, Answer 2, Answer 3 (paragraph break) The problem is that I'm exporting data from a Google Docs Form -> Spreadsheet that's structured like this: This was a long 3-day ordeal to find this solution, so I wanted to be thorough for someone else out there.Д«e sure to post your solutions to nasty ones like this you figure out. Use Change All to get all your line breaks back.

Test it on just one with Find then Change.

Next to the Replace field click the button and select 'Force Line Break'.

Type your special string into the Find field.Click (command + F) or (Edit > Find/Change) to open Find and Replace.Replace your special character with real line breaks.I picked '' but anything would work, i.e.Place your special character into the Replace field.Paste the line break into the Find/Replace Tool.Click (command + F) or (Edit > Find) to open Find and Replace.Select from the end of one line to the next.Replace line breaks with a special string in your CSV data file.Creating an automated 'Find/Change' makes it very simple. Also, automation is not available.)Д¬ase closed. (I also tried doing this with all the data in XML format, but that requires almost a 1:1 ratio of creating, tagging and styling each field. Then, command-F to Find/Change all the 's: NOT with a 'forced line break' but an 'end paragraph' symbol (which looks like 'в€§p') This allows for Bullet/List formatting to properly display the sequence of procedures. Keeping the procedures in the same field, separated by a unique string (I chose to make the text readable in other formats outside ID) is the way to go. You have to enter empty quotes to indicate no content in every field in the source doc, and then remove the excess list items in the target document. And, the Document is considerably less flexible, demanding a lot of extra work to make it presentable. It is definitely more work to create a unique field for each procedure in the database.

Excel for mac escape single quotes in csv