Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? -- theogtlc ------------------------------------------------------------------------ theogtlc's Profile: http://www.excelforum.com/member.php...o&userid=36996 View this thread: http://www.excelforum.com/showthread...hreadid=567198 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to insert a soft return into a single cell | Excel Discussion (Misc queries) | |||
soft return | Excel Discussion (Misc queries) | |||
Asci equivalent of soft return (alt+enter) | Excel Programming | |||
Hard breaks in text to soft breaks in Excel | Excel Discussion (Misc queries) | |||
Hard breaks in text to soft breaks in Excel | Excel Programming |