Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import text to Excel
I have a problem when importing text to Excel (2003).
I have a Word-document with 1 000 paragraphs. Some of the paragraphs only have one short line of text but most of them consist of several lines of text separated by a manual line break. It is crucial to keep the line breaks. When I paste the data into Excel the text is placed in cells on a "line-by-line" basis and not paragraph by paragraph. Each line of text in the word document is placed in its own cell. I want each paragraph to go in one cell and on the same time keep the manual line breaks inside the cell. I guess part of the problem is that in Excel a hard line break is Alt+Enter and in Word Shift+Enter. Anyone got a workaround for this? -- Fredrik E. Nilsen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
How to import plain text into workable tables/cells? | Excel Discussion (Misc queries) | |||
How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
setting text qualifier in Excel | Excel Discussion (Misc queries) |