Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Browse For a File or Path and enter in a cell D. Jones Excel Discussion (Misc queries) 5 November 9th 07 04:07 PM
formatting a cell to display a word when i enter a reference lette megan62685 Excel Discussion (Misc queries) 2 June 14th 07 06:44 PM
How come I need to enter a cell in order for the formatting to apply correctly??? [email protected] Excel Discussion (Misc queries) 1 October 17th 06 08:08 PM
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? PaulH_1980 Excel Worksheet Functions 1 March 15th 06 11:51 PM
embed <alt<enter for multiline cell in a CSV file John Lopez Excel Programming 3 October 14th 03 03:41 PM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"