Excel web page soft returns

  • Thread starter Excel web page soft return ALT + ENTER?
  • Start date
E

Excel web page soft return ALT + ENTER?

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...
<% 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...
<% 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
<% Response.Write Replace(rsx("Text"), vbCrLf, chr(13)&chr(10))%>
but they just don't take.
Does any one know if there is any possible way to maintain the formatting
within one cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PLEASE HELP! ASP to Excel Convert hard to soft return 0
ASP Script to Send an email which generates into a HTML format 2
Soft Carriage Return 6
Carriage Return Symbol Text Field Word Form VBA Problem inside Tab 2
Replace Carriage Return ASCII Character in Memo Field 3
Code that was working doesn't anymore -Remove ALT-ENTER from Excel 4
Soft Returns 5
Format String in Table Cell 1

Top