Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
embed <alt<enter for multiline cell in a CSV file
Hi,
I have a database program (MatrixOne, with Oracle as middleware) that parses data returned from a query, then writes a CSV file, and finally launches it with Excel for the users view. I know there are better ways, but this is what we have right now. I need to embed an <alt<enter in the cell contents as a new line delimeter, so as to create multiline cell data. I have attempted to write an octal \034 between the data pieces, but it does not really do what I need, just creates a nonprinting character in the string, which remains linear. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to paste multiline HTML into a single cell in Excel 2003? | Excel Discussion (Misc queries) | |||
Browse For a File or Path and enter in a cell | Excel Discussion (Misc queries) | |||
import multiline data from text file | Excel Discussion (Misc queries) | |||
Importing a multiline .txt file | Excel Discussion (Misc queries) | |||
Fixing multiline cell | Excel Worksheet Functions |