PLEASE HELP! ASP to Excel Convert hard to soft return

[theogtlc]

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?