Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
#6
|
|||
|
|||
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) |
#7
|
|||
|
|||
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) |
#8
|
|||
|
|||
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? |
#9
|
|||
|
|||
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? |
#10
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
#13
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paragraph doesn't break even after hard return. | Page Layout | |||
Hard time with page breaks | Formatting Long Documents | |||
Extra line spacing at top of page after a soft page break | Microsoft Word Help | |||
Convert Footnotes to Hard Text ??? | Formatting Long Documents | |||
Continuous breaks convert to next page breaks | Microsoft Word Help |