Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how formatting CSV file to get alt-enter text in one cell
Hi !
I would like to know how must i format a multi-line text in a csv file to get the whole text in one cell (like if i have typed it with the alt-enter between each line of text). If i try to export an excel file with a cell with a 2-lines text, i get : "LINE1 LINE2" with a chr(10) between the two. But if import this csv, i get two cells, each with only one line of text. Is there a solution ? Thanks for your help. Sylvain Caillet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Browse For a File or Path and enter in a cell | Excel Discussion (Misc queries) | |||
formatting a cell to display a word when i enter a reference lette | Excel Discussion (Misc queries) | |||
How come I need to enter a cell in order for the formatting to apply correctly??? | Excel Discussion (Misc queries) | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
embed <alt<enter for multiline cell in a CSV file | Excel Programming |