Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing line breaks into separate cells | Excel Discussion (Misc queries) | |||
how do I remove line breaks from several cells? | Excel Discussion (Misc queries) | |||
Removing Manual Line Breaks in Multiple Cells | Excel Discussion (Misc queries) | |||
Line Breaks in cells - Mac OS X Leopard | Excel Discussion (Misc queries) | |||
Line breaks in my cells... | Excel Discussion (Misc queries) |