Exclel carriage return

[pyelle]

Hello all,
can anyone indicate the character used to insert a carriage return within a same cell in Excel.

 

[Pat McMillan]

Control + Option + <return>

Hello all,
can anyone indicate the character used to insert a carriage return within a
same cell in Excel.

 

[pyelle]

Hello Pat, thanks for this answer,

I am building an HTML layout and feeding to Excel to open after download.

<br> creates rows.

I want to input the chararcetr that will be interpreted as an Control + Option +

I am cycling thru records at this point and building a var called $excel

$excel +='<td class="ro"><ol>';
records;
$excel +=(Field:'aut_name_full')' - '(Field:'aut_inst_name')'<br>';
/records;
$excel +='</ol></td>';

The <br> is what I need to change into something that will be interpreted by Excel as a same cell carriage retrurn

Thanks for any input

Pierre