View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RealGomer
 
Posts: n/a
Default Changing data from one line to multiple

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.