If you're building a tab delimited file, then I think you're going to have to
find a different way.

Excel will see those alt-enters as new lines and import that data into a new
row.



Lorenzo wrote:
>
> "Dave Peterson" <petersod@verizonXSPAM.net> ha scritto nel messaggio
> news:44AC07D1.C1CD0CF3@verizonXSPAM.net...
> > How are you sending that value to excel?
>
> I build an xls file as tab-delimited
>
> > If you're relying on windows pasting the value, then maybe you could
> > substitute
> > a different (unique) string (|) and then change that to alt-enter
> > (char(10)).
> >
>
> i can't sobstitute after file creation, it is send to web client

--

Dave Peterson