Changing data from one line to multiple

[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.
--
I know enuff to be dangerous.

[Anne Troy]

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" <RealGomer@discussions.microsoft.com> wrote in message
news:7C9BEB05-1FFC-432B-AC78-1F7D6EAB158B@microsoft.com...
> 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.

[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.
--
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" <RealGomer@discussions.microsoft.com> wrote in message
> news:7C9BEB05-1FFC-432B-AC78-1F7D6EAB158B@microsoft.com...
> > 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.
>
>
>

[Anne Troy]

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

"RealGomer" <RealGomer@discussions.microsoft.com> wrote in message
news:244C4179-FBF2-4B86-829A-D530771C1DB8@microsoft.com...
> 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" <RealGomer@discussions.microsoft.com> wrote in message
>> news:7C9BEB05-1FFC-432B-AC78-1F7D6EAB158B@microsoft.com...
>> > 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]

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