I have Word 2002. I am copying a mailing list from the web into Word and want
to convert it from table to text, which I know how to do. I am then going to
copy into Excel.

Problem is, there are 5 lines per entry. Each line is separated by what I
call a soft break (shift/enter). I can't copy these into Excel this way so
the information shows up in 5 separate columns.

Is there any way to convert these soft breaks into hard breaks (enter key
only) without having to go line by line?

Find/Replace (Ctrl+H) and put ^l into the find and ^p into the replace, and
replace all. ^l is a lower-case L by the way.
************
Anne Troy
www.OfficeArticles.com

"KathfromWI" <(E-Mail Removed)> wrote in message
news:B7BD57DE-2820-4D6A-8B06-(E-Mail Removed)...
>I have Word 2002. I am copying a mailing list from the web into Word and
>want
> to convert it from table to text, which I know how to do. I am then going
> to
> copy into Excel.
>
> Problem is, there are 5 lines per entry. Each line is separated by what I
> call a soft break (shift/enter). I can't copy these into Excel this way so
> the information shows up in 5 separate columns.
>
> Is there any way to convert these soft breaks into hard breaks (enter key
> only) without having to go line by line?

You can do this easily with Find and Replace:

Find ^l (caret, lower case letter L)
Replace with ^p (caret, lower case letter P)

Hit Replace All and you should be done.

Enjoy,
Tony


"KathfromWI" wrote:

> I have Word 2002. I am copying a mailing list from the web into Word and want
> to convert it from table to text, which I know how to do. I am then going to
> copy into Excel.
>
> Problem is, there are 5 lines per entry. Each line is separated by what I
> call a soft break (shift/enter). I can't copy these into Excel this way so
> the information shows up in 5 separate columns.
>
> Is there any way to convert these soft breaks into hard breaks (enter key
> only) without having to go line by line?

That worked - thanks so much Tony! I would have never figured that one out.

Kath

"Tony Jollans" wrote:

> You can do this easily with Find and Replace:
>
> Find ^l (caret, lower case letter L)
> Replace with ^p (caret, lower case letter P)
>
> Hit Replace All and you should be done.
>
> Enjoy,
> Tony
>
>
> "KathfromWI" wrote:
>
> > I have Word 2002. I am copying a mailing list from the web into Word and want
> > to convert it from table to text, which I know how to do. I am then going to
> > copy into Excel.
> >
> > Problem is, there are 5 lines per entry. Each line is separated by what I
> > call a soft break (shift/enter). I can't copy these into Excel this way so
> > the information shows up in 5 separate columns.
> >
> > Is there any way to convert these soft breaks into hard breaks (enter key
> > only) without having to go line by line?

Sure. Come along one minute after me, and make me look bad. I see how you
are!!

Great to see you here, Tony!
************
Anne Troy
www.OfficeArticles.com

"Tony Jollans" <(E-Mail Removed)> wrote in message
news:EE43783F-204E-41F4-AEB7-(E-Mail Removed)...
> You can do this easily with Find and Replace:
>
> Find ^l (caret, lower case letter L)
> Replace with ^p (caret, lower case letter P)
>
> Hit Replace All and you should be done.
>
> Enjoy,
> Tony
>
>
> "KathfromWI" wrote:
>
>> I have Word 2002. I am copying a mailing list from the web into Word and
>> want
>> to convert it from table to text, which I know how to do. I am then going
>> to
>> copy into Excel.
>>
>> Problem is, there are 5 lines per entry. Each line is separated by what I
>> call a soft break (shift/enter). I can't copy these into Excel this way
>> so
>> the information shows up in 5 separate columns.
>>
>> Is there any way to convert these soft breaks into hard breaks (enter key
>> only) without having to go line by line?

LOL - I didn't know you hung out here, Anne - as well as everywhere else

I drop in occasionally but find it painfully slow so don't usually stay
long. Maybe better when I get broadband.

"Anne Troy" wrote:

> Sure. Come along one minute after me, and make me look bad. I see how you
> are!!
>
> Great to see you here, Tony!
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Tony Jollans" <(E-Mail Removed)> wrote in message
> news:EE43783F-204E-41F4-AEB7-(E-Mail Removed)...
> > You can do this easily with Find and Replace:
> >
> > Find ^l (caret, lower case letter L)
> > Replace with ^p (caret, lower case letter P)
> >
> > Hit Replace All and you should be done.
> >
> > Enjoy,
> > Tony
> >
> >
> > "KathfromWI" wrote:
> >
> >> I have Word 2002. I am copying a mailing list from the web into Word and
> >> want
> >> to convert it from table to text, which I know how to do. I am then going
> >> to
> >> copy into Excel.
> >>
> >> Problem is, there are 5 lines per entry. Each line is separated by what I
> >> call a soft break (shift/enter). I can't copy these into Excel this way
> >> so
> >> the information shows up in 5 separate columns.
> >>
> >> Is there any way to convert these soft breaks into hard breaks (enter key
> >> only) without having to go line by line?
>
>
>

Glad it helped, Kath.

You don't need to know all the cryptic codes. In the Find/Replace dialog
there is a button labelled "More". If you click it, there are some extra
options and those codes can be selected from a list in English (or whatever
your language is) by pressing "Special"

Enjoy,
Tony

"KathfromWI" wrote:

> That worked - thanks so much Tony! I would have never figured that one out.
>
> Kath
>
> "Tony Jollans" wrote:
>
> > You can do this easily with Find and Replace:
> >
> > Find ^l (caret, lower case letter L)
> > Replace with ^p (caret, lower case letter P)
> >
> > Hit Replace All and you should be done.
> >
> > Enjoy,
> > Tony
> >
> >
> > "KathfromWI" wrote:
> >
> > > I have Word 2002. I am copying a mailing list from the web into Word and want
> > > to convert it from table to text, which I know how to do. I am then going to
> > > copy into Excel.
> > >
> > > Problem is, there are 5 lines per entry. Each line is separated by what I
> > > call a soft break (shift/enter). I can't copy these into Excel this way so
> > > the information shows up in 5 separate columns.
> > >
> > > Is there any way to convert these soft breaks into hard breaks (enter key
> > > only) without having to go line by line?

If you want to apply that change to multiple Word documents, try
WordPipe (www.datamystic.com). It also allows those same codes to be
used, but automatically across thousands of documents.

> > > Find ^l (caret, lower case letter L)
> > > Replace with ^p (caret, lower case letter P)

Pretty expensive for an overblown macro.
************
Anne Troy
www.OfficeArticles.com

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If you want to apply that change to multiple Word documents, try
> WordPipe (www.datamystic.com). It also allows those same codes to be
> used, but automatically across thousands of documents.
>
>> > > Find ^l (caret, lower case letter L)
>> > > Replace with ^p (caret, lower case letter P)
>

If you find the web portals slow, access via Usenet -
http://www.gmayor.com/MSNews.htm
Download the messages and you can work at your own pace off line.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Tony Jollans wrote:
> LOL - I didn't know you hung out here, Anne - as well as everywhere
> else
>
> I drop in occasionally but find it painfully slow so don't usually
> stay long. Maybe better when I get broadband.
>
> "Anne Troy" wrote:
>
>> Sure. Come along one minute after me, and make me look bad. I see
>> how you are!!
>>
>> Great to see you here, Tony!
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "Tony Jollans" <(E-Mail Removed)> wrote in
>> message news:EE43783F-204E-41F4-AEB7-(E-Mail Removed)...
>>> You can do this easily with Find and Replace:
>>>
>>> Find ^l (caret, lower case letter L)
>>> Replace with ^p (caret, lower case letter P)
>>>
>>> Hit Replace All and you should be done.
>>>
>>> Enjoy,
>>> Tony
>>>
>>>
>>> "KathfromWI" wrote:
>>>
>>>> I have Word 2002. I am copying a mailing list from the web into
>>>> Word and want
>>>> to convert it from table to text, which I know how to do. I am
>>>> then going to
>>>> copy into Excel.
>>>>
>>>> Problem is, there are 5 lines per entry. Each line is separated by
>>>> what I call a soft break (shift/enter). I can't copy these into
>>>> Excel this way so
>>>> the information shows up in 5 separate columns.
>>>>
>>>> Is there any way to convert these soft breaks into hard breaks
>>>> (enter key only) without having to go line by line?