how formatting CSV file to get alt-enter text in one cell

S

sylvain

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top