Convert soft breaks (shift/return) into hard breaks (return).

[Guest]

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?

 

[Anne Troy]

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

 

[Guest]

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

 

[Guest]

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

Kath

 

[Anne Troy]

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

 

[Guest]

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.

 

[Guest]

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

 

[datamystic]

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.

 

[Anne Troy]

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

 

[Graham Mayor]

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

Thanks, Graham.

I can't keep up with all this modern technology - I can't even keep up with
Word

Tony

 

[Tony Jollans]

Thanks again, Graham.

After downloading thousands of messages I can now look at them a hundred
times more quickly.

This is just a test to see if I can reply.

Enjoy,

Tony

 

[Anne Troy]

Graham: GREAT job suckering Tony right in like that. Kudos!! He's a great
guy to have around. IMHO, he should'a been one of you guys a LOOOOOOONG time
ago.
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

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