Thank You!
Unfortunately in the same case excel break text cel in a new row.

Without knowing what strXLS or fld.value is, either.

strXls, is a variable that contain the output in excel
fld.value, is the value of a field of db that can contain some break line
and i must send it in a unique cel

sorry again for my english

Lorenzo


"Dave Peterson" ha scritto nel messaggio
...
I don't speak the ASP, but maybe....

strXls = strXls & replace(fld.value,vbCr,vblf)

or

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

Without knowing what strXLS or fld.value is, either.

Lorenzo wrote:

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

--

Dave Peterson