>Hi Friends!
>
>I´m having a little trouble exporting data from a memo field to Excel. everything works fine with this code:
>
>
WITH .RANGE("B4")
> .VALUE = dgeneral.gpoliticos
> .HorizontalAlignment = xlLeft
> .WrapText = True
>ENDWITH
>
>But once the data are on cell, appear some square sign that means the intro keys. Something like this:
>
>
Hello
>World,
>what´s new? I think it´s a incredible
>site to ask about VFP!
>
>Is there a way to correct it?
>
>Thanks in advance!
Try:
.VALUE = chrtran(dgeneral.gpoliticos,chr(13),"")
or
.VALUE = chrtran(dgeneral.gpoliticos,chr(13)+chr(10),"")
or
.VALUE = strtran(dgeneral.gpoliticos,chr(13),chr(13)+chr(10))