LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to paste multiline HTML into a single cell in Excel 2003? Ker_01 Excel Discussion (Misc queries) 2 February 22nd 08 11:57 AM
Browse For a File or Path and enter in a cell D. Jones Excel Discussion (Misc queries) 5 November 9th 07 04:07 PM
import multiline data from text file Razorback76 Excel Discussion (Misc queries) 0 June 20th 06 06:13 AM
Importing a multiline .txt file schnett Excel Discussion (Misc queries) 13 April 24th 06 11:06 PM
Fixing multiline cell TonyL Excel Worksheet Functions 2 April 6th 06 02:14 PM


All times are GMT +1. The time now is 10:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"