Changing data from one line to multiple

R

RealGomer

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.
 
D

Dave Peterson

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

Format|cells|Alignment tab|Check wraptext
 
R

RealGomer

You know, Anne, that's exactly what I finally did. Word sucked it right in
(after it decided to load and function. Had that problem since Word 95. Must
be bad coding.)
Once I had it in word, I used Edit - Select All and copied the kit and
kaboodle back into Excel. Bingo, bango, bongo, everything was where it needed
to be.
The report is being used to create a newspaper advert of various miscreants
who don't want to pay their taxes (such as a certain cable company that is
owned in part by a certain internet portal). We put the advert into Excel so
we can do multiple other reports and it makes it easier to whack those that
realize our treasurer can seize everything they own if they don't pay.
 
Top