Writing few lines to Excel cell

Hello, I am using XLSWRITE in order to write to Excel file and it works well. My problem is that I would like to write to a single cell a few lines. For instance I would like to write :

'0-12,10
50-60,9
70-76,2'

all in one cell. Currently I only to do it in one row : ''0-12,10,50-60,9,70-76,2' Do you have any idea how to force Alt-Enter?

Best, Tamir

Answer 1

[Image Analyst]

A total SWAG, but try this:

% Create a cell with one multi-line string in it.
oneCell = {sprintf('0-12,10\n,50-60,9\n70-76,2')}
% Write out to Excel
xlswrite(filename, oneCell, 'A1');

[Image Analyst]

If \n doesn't work, try \r, \r\n, or \n\r.

[Tamir]

Works great! Thanks a lot!

[Image Analyst]

For others who might read this, which one(s) worked?