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.

Changing data from one line to multiple
 

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

"RealGomer" wrote in message
...
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.

Changing data from one line to multiple
 

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

Changing data from one line to multiple
 

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.


"Anne Troy" wrote:

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

"RealGomer" wrote in message
...
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.

Changing data from one line to multiple
 

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

"RealGomer" wrote in message
...
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.


"Anne Troy" wrote:

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

"RealGomer" wrote in message
...
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.