Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Text with Carriage Returns inside cell values
I am trying to import TAB delimited text from an application. The number of
columns in each row is always fixed, but the values in one column include carriage returns, since they are text with paragraphs. Is there any way to import them as single text values into excel? example format : Name [TAB] Description [TAB] Parent Name example row: John [TAB] John is a farmer. His dad's name is Joe. He works very hard. [TAB] Joe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Text with Carriage Returns inside cell values
I've always gone back to the program that generated the text file and had those
internal linefeeds/carriage returns changed to a unique/unused character--maybe the vertical bar??? Then import the data and change that character to the alt-enter (linefeed). Ryan L wrote: I am trying to import TAB delimited text from an application. The number of columns in each row is always fixed, but the values in one column include carriage returns, since they are text with paragraphs. Is there any way to import them as single text values into excel? example format : Name [TAB] Description [TAB] Parent Name example row: John [TAB] John is a farmer. His dad's name is Joe. He works very hard. [TAB] Joe -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove carriage returns from a cell | Excel Worksheet Functions | |||
Can I insert 'carriage/line returns' in text string? | Excel Worksheet Functions | |||
How can I enter carriage returns into text within a cell in excel | Excel Discussion (Misc queries) | |||
How do I eliminate carriage returns in a cell | Charts and Charting in Excel | |||
How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) |