Line break in excel cell

[lucasesr]

Good morning guys.

I created a procedure to generate a .csv file with the data of a cursor.
The creation of the file is working, but has a column that I step set up some information that should be as follows, all within the same cell in Excel.

Ex:
Name:
Phone:
E-mail:

How is being implemented:

Select all

V_1 := 'Nome: '||CHR(13)|| 
		 'Telefone: '||CHR(13)|| 
		 'E-mail: ';

But the problem is that Excel understands that CHR (13) or CHR (10) is Line break, and next information after CHR (13) of this for the next line of the worksheet.

Does anyone know how to break line within the cell itself, simulating the "alt-enter" of Excel?

Thanks.
Thanks.

[dr_gori]

I did not test, but I found it strange that Excel himself uses CHR 10.
In this link give the tip: http://blog.softartisans.com/2012/02/16 ... -in-excel/
: Roll:

[lucasesr]

Thank you Dr_Gori by the tip.

But I found a solution, very simple by the way.

Excel does not identify CHR (10) or CHR (13), making the line.

The solution was to put all the text inside double quotation marks and giving enter where I want to break the line inside the cell. Getting as follows.

Select all

		V_BANDA := '"Nome do Solicitante 
Dois Telefones para Contato 
Nome da Banda 
Data do Embarque 
Data e Horário do Show 
Trecho 
Voo 
Quantidade de Volumes 
Peso Total 
Valor da Cotação";';

Obs.: Where you press Enter should not be no space or tab, otherwise, in Excel is characters. So do not connect to Ends in this section

With this, all this information is all within the same cell.

Thank you very much.