View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lorenzo Lorenzo is offline
external usenet poster
 
Posts: 6
Default break line in text cell from ASP

hi to all, sorry for my little little english.

i wont to export in excel from sql by asp

if in a field there is a chr(13), excel send to new row the text. What i do
to tell excel go in a new line in the same cell?

i try so but don't work:

strXls = strXls & replace(fld.value,vbCrLf,Chr(10))

many thanks

Lorenzo