>I recall we need to use just chr(10). Try that and Bill's suggestion too.
I think Bill is right that the column has to be set to Word Wrap. I use the class VFPxWorkbookXLSX developed by Greg Green to create an Excel file. This class, from the documentation, has the method SetCellWordWrap and a parameter tlWordWrap. But I don't understand how to apply it to my code. In my code, I use just one line:
*-- The cursor is which is converted to Excel is open at this point. Then simply calling the method
*-- SaveTabletoWorkbook() (as seen below) creates excel.
loExcel.SaveTabletoWorkbook(lcCursorName, cExcelFileName, .T., .T., tcWorkSheetName)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham