Forum Discussion
Excel Delimiter for a Paragraph Break
I have a large sum of data from a word document I need to copy and paste into excel. An example of the format is below (don’t worry it’s not actually children’s rhymes): roses are red violets a...
I've tested the copy/paste between Word and Excel with the first poem. I've used paragraph breaks and shift+enter after each line, no matter how I do it, Excel brings in the lines cleanly (1 line= cell cell). The same for any paste option I've tried in Excel (e.g. Keep source formatting, use destination formatting, plain text, etc.).
A sample document would really help. The unknown part for me is how the text got in the Word document. Was it keyed in manually or did a non-Office app produce the document? If it's the latter, there's a chance there could be more than meets the eye, formatting-wise in the document.
A sample document would really help. The unknown part for me is how the text got in the Word document. Was it keyed in manually or did a non-Office app produce the document? If it's the latter, there's a chance there could be more than meets the eye, formatting-wise in the document.
