ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how formatting CSV file to get alt-enter text in one cell (https://www.excelbanter.com/excel-programming/290336-how-formatting-csv-file-get-alt-enter-text-one-cell.html)

sylvain[_2_]

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




All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com