Hi<BR><BR>I am using OWC components to create a spreadsheet. I am running into scenarios where a single field(string - with spaces) is spread over a few rows - it is strange because some fields of greater length are written to one cell whereas some fields are spread through 3 rows. The cell to field mapping is set in the syntax below...<BR><BR>objSpreadsheet.Cells(iRow, iCol).Value = CStr(objField.Value)<BR><BR>I have tried using substring function in SQL, Cstr in ASP and still no luck.<BR><BR>Would greatly appreciate any help!