software

I've generated a report that when exported to Crystal or Adobe has the data
like this:
quot;1133 SYCAMORE STREET LLC
6728 HYLAND CROY RD
DUBLIN, OH 43016quot;

When I try to export it to Excel, either as CSV or XLS (or to Access), the
data is like this:
quot;1133 SYCAMORE STREET LLCâ—‹6728 HYLAND CROY RDâ—‹DUBLIN, OH 43016quot;
(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.

Why not export to Word, which handles paragraphical text much better?
What's the ultimate use of it?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;RealGomerquot; gt; wrote in message
...
gt; I've generated a report that when exported to Crystal or Adobe has the
gt; data
gt; like this:
gt; quot;1133 SYCAMORE STREET LLC
gt; 6728 HYLAND CROY RD
gt; DUBLIN, OH 43016quot;
gt;
gt; When I try to export it to Excel, either as CSV or XLS (or to Access), the
gt; data is like this:
gt; quot;1133 SYCAMORE STREET LLC?6728 HYLAND CROY RD?DUBLIN, OH 43016quot;
gt; (The circles are supposed to be squares; I couldn't find anything in the
gt; ASCII chart)
gt;
gt; How can I get the data formatted in Excel (or Access) to be like the
gt; original report.
gt; --
gt; I know enuff to be dangerous.
If that square is a linefeed character, maybe just changing toggling wraptext
would help:

Format|cells|Alignment tab|Check wraptext

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

--

Dave Peterson

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.
--
I know enuff to be dangerous.quot;Anne Troyquot; wrote:

gt; Why not export to Word, which handles paragraphical text much better?
gt; What's the ultimate use of it?
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;RealGomerquot; gt; wrote in message
gt; ...
gt; gt; I've generated a report that when exported to Crystal or Adobe has the
gt; gt; data
gt; gt; like this:
gt; gt; quot;1133 SYCAMORE STREET LLC
gt; gt; 6728 HYLAND CROY RD
gt; gt; DUBLIN, OH 43016quot;
gt; gt;
gt; gt; When I try to export it to Excel, either as CSV or XLS (or to Access), the
gt; gt; data is like this:
gt; gt; quot;1133 SYCAMORE STREET LLC?6728 HYLAND CROY RD?DUBLIN, OH 43016quot;
gt; gt; (The circles are supposed to be squares; I couldn't find anything in the
gt; gt; ASCII chart)
gt; gt;
gt; gt; How can I get the data formatted in Excel (or Access) to be like the
gt; gt; original report.
gt; gt; --
gt; gt; I know enuff to be dangerous.
gt;
gt;
gt;

EXCELLENT, Gomer. Go get 'em!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;RealGomerquot; gt; wrote in message
...
gt; You know, Anne, that's exactly what I finally did. Word sucked it right in
gt; (after it decided to load and function. Had that problem since Word 95.
gt; Must
gt; be bad coding.)
gt; Once I had it in word, I used Edit - Select All and copied the kit and
gt; kaboodle back into Excel. Bingo, bango, bongo, everything was where it
gt; needed
gt; to be.
gt; The report is being used to create a newspaper advert of various
gt; miscreants
gt; who don't want to pay their taxes (such as a certain cable company that is
gt; owned in part by a certain internet portal). We put the advert into Excel
gt; so
gt; we can do multiple other reports and it makes it easier to whack those
gt; that
gt; realize our treasurer can seize everything they own if they don't pay.
gt; --
gt; I know enuff to be dangerous.
gt;
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; Why not export to Word, which handles paragraphical text much better?
gt;gt; What's the ultimate use of it?
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;RealGomerquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I've generated a report that when exported to Crystal or Adobe has the
gt;gt; gt; data
gt;gt; gt; like this:
gt;gt; gt; quot;1133 SYCAMORE STREET LLC
gt;gt; gt; 6728 HYLAND CROY RD
gt;gt; gt; DUBLIN, OH 43016quot;
gt;gt; gt;
gt;gt; gt; When I try to export it to Excel, either as CSV or XLS (or to Access),
gt;gt; gt; the
gt;gt; gt; data is like this:
gt;gt; gt; quot;1133 SYCAMORE STREET LLC?6728 HYLAND CROY RD?DUBLIN, OH 43016quot;
gt;gt; gt; (The circles are supposed to be squares; I couldn't find anything in
gt;gt; gt; the
gt;gt; gt; ASCII chart)
gt;gt; gt;
gt;gt; gt; How can I get the data formatted in Excel (or Access) to be like the
gt;gt; gt; original report.
gt;gt; gt; --
gt;gt; gt; I know enuff to be dangerous.
gt;gt;
gt;gt;
gt;gt;