Ok I know this question is going to be all over the map. First of I have an ASP sight which pulls info from a database and then is formatted to a excel web sheet.
My problem is, is that when ever the customer inputs thier info with a <ENTER> or vbCrLf it causes the data to shift to a new cell row. Yet if I don't do the ....
<% Response.Write Replace(rsx("Text"), vbCrLf, "<br/>")%>
It all remains in one cell.
In excel to have a character return you have to ALT+ENTER
does any one know if there is a value for this key combination that will work?