PLEASE HELP! ASP to Excel Convert hard to soft return
 

I am currently pulling in some information form a data base into an asp
page
which is then output to an excel web page. My issue I am having is if
I
use...

Code:
--------------------
<% Response.Write Replace(rsx("Text"), vbCrLf, <br)%
--------------------
It makes the data jump to the next cell instead of keeping it all in one
cell.
I've tried programming for a soft return...

Code:
--------------------
<% Response.Write Replace(rsx("Text"), vbCrLf, chr(10))% or
<% Response.Write Replace(rsx("Text"), vbCrLf, chr(13))% or
<% Response.Write Replace(rsx("Text"), vbCrLf, chr(10)&chr(13))%
--------------------
or

Code:
--------------------
<% Response.Write Replace(rsx("Text"), vbCrLf, chr(13)&chr(10))%
--------------------
but they just don't take.

I've even tried the alt special character 10.
Does any one know if there is any possible way to maintain the
formatting
within one cell?:confused:


--
theogtlc
------------------------------------------------------------------------
theogtlc's Profile: http://www.excelforum.com/member.php...o&userid=36996
View this thread: http://www.excelforum.com/showthread...hreadid=567198