If that square is a linefeed character, maybe just changing toggling wraptext
would help:

Format|cells|Alignment tab|Check wraptext

RealGomer wrote:
>
> I've generated a report that when exported to Crystal or Adobe has the data
> like this:
> "1133 SYCAMORE STREET LLC
> 6728 HYLAND CROY RD
> DUBLIN, OH 43016"
>
> When I try to export it to Excel, either as CSV or XLS (or to Access), the
> data is like this:
> "1133 SYCAMORE STREET LLC○6728 HYLAND CROY RD○DUBLIN, OH 43016"
> (The circles are supposed to be squares; I couldn't find anything in the
> ASCII chart)
>
> How can I get the data formatted in Excel (or Access) to be like the
> original report.
> --
> I know enuff to be dangerous.

--

Dave Peterson