View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TheVisionThing TheVisionThing is offline
external usenet poster
 
Posts: 22
Default Programming Line Breaks into Cells

I'm writing resumes from a database field into individual single cells in a
spreadsheet (one resume per cell). The problem is that line breaks in the
resumes are not being carried over into the single cells.

This is the function I'm using to correct this problem, but it's not
working.
-----------------------

Function ConvertTextAreaExcel(strText)
'inserts line breaks when displaying textarea data in an Excel cell
If strText < "" then
ConvertTextAreaExcel = Replace(strText, chr(13),vbCRLF)
End If
End Function
-----------------------
Thanks,
Wayne C.