Reply
 
Thread Tools Display Modes
  #1   Report Post  
KathfromWI
 
Posts: n/a
Default Convert soft breaks (shift/return) into hard breaks (return).

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?
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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



  #3   Report Post  
Tony Jollans
 
Posts: n/a
Default

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?

  #4   Report Post  
KathfromWI
 
Posts: n/a
Default

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?

  #5   Report Post  
Anne Troy
 
Posts: n/a
Default

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





  #6   Report Post  
Tony Jollans
 
Posts: n/a
Default

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




  #7   Report Post  
Tony Jollans
 
Posts: n/a
Default

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?

  #8   Report Post  
 
Posts: n/a
Default

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)


  #9   Report Post  
Anne Troy
 
Posts: n/a
Default

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

wrote in message
oups.com...
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)




  #10   Report Post  
Graham Mayor
 
Posts: n/a
Default

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





  #11   Report Post  
Tony Jollans
 
Posts: n/a
Default


Thanks, Graham.

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

Tony


"Graham Mayor" wrote:

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




  #12   Report Post  
Tony Jollans
 
Posts: n/a
Default

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

"Tony Jollans" wrote in message
...

Thanks, Graham.

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

with
Word

Tony


"Graham Mayor" wrote:

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






  #13   Report Post  
Anne Troy
 
Posts: n/a
Default

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

"Graham Mayor" wrote in message
...
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" wrote in
message ...
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?





  #14   Report Post  
Posted to microsoft.public.word.docmanagement
Ken Gardiner Ken Gardiner is offline
external usenet poster
 
Posts: 1
Default Convert soft breaks (shift/return) into hard breaks (return).



"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?

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Paragraph doesn't break even after hard return. Skuba Page Layout 1 July 24th 05 08:44 AM
Hard time with page breaks Gadifer Formatting Long Documents 1 April 18th 05 05:07 PM
Extra line spacing at top of page after a soft page break SteveP Microsoft Word Help 1 April 1st 05 05:01 PM
Convert Footnotes to Hard Text ??? Formatting Long Documents 3 January 19th 05 03:41 AM
Continuous breaks convert to next page breaks Jennifer Hunt Microsoft Word Help 2 December 30th 04 06:45 PM


All times are GMT +1. The time now is 03:48 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"