View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sylvain[_2_] sylvain[_2_] is offline
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