I think that is to drop to the next cell, but I just want a break in the cell(alt-enter in excel)
-----Original Message----- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 11, 2006 1:04 PM To: CF-Talk Subject: Re: chr(10) in excel Try #chr(13)##chr(10)#? On 4/11/06, Turetsky, Seth <[EMAIL PROTECTED]> wrote: > Hi, > I have a page that pops up in excel, but I want line wraps within cells. I > tried chr(10) but it doesn't seem to respect it. > Has anyone done this or can they try this(i'm using BD now), I vaguely > remember this working in the past. > Thanks, > Seth > > <!---test code---> > <CFHEADER NAME="Expires" VALUE="Mon, 06 Jan 1990 00:00:01 GMT"> > <CFHEADER NAME="Pragma" VALUE="no-cache"> > <CFHEADER NAME="cache-control" VALUE="no-cache"> > > <META HTTP-EQUIV="Expires" CONTENT="Mon, 06 Jan 1990 00:00:01 GMT"> > <META HTTP-EQUIV="Pragma" CONTENT="no-cache"> > <META HTTP-EQUIV="Cache-Control" CONTENT="no-cache"> > > <cfheader name="Content-disposition" > value="attachment;filename=spreadsheet.xls"> > <cfcontent type="application/vnd.ms-excel"> > > <cfoutput>line1a#chr(10)#line1b > line2a#chr(10)#line2b</cfoutput> > > ============================================================================== > Please access the attached hyperlink for an important electronic > communications disclaimer: > > http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html > ============================================================================== > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237440 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54