Version 5.0 - Build 766
If you export a text area field (not HTML or rich text editor) to Excel (not Word) that has multiple lines, it appears the carriage return/line feed is replaced with a space during the export and the entire field runs together within the Excel cell.
Changing the field to HTML and using the rich text editor is NOT a solution as this causes a NEW ROW to be created for each line in the text field.
Is there a way to export a text area field which contains multiple lines (carriage return/line feed) to Excel (not Word) and have those multiple lines preserved within a single Excel cell/row?
I'm using Excel from Office 2000 in case the version is an issue.
Thanks so much for any help. Take Care... Mike.