Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
guest in calif guest in calif is offline
external usenet poster
 
Posts: 1
Default How do I remove all carriage returns from a Word document?

Does anyone have a quick solution to remove all carriage returns from a Word
document?

I would also like to know how to remove empty lines in excel that result
when I cut and paste data from PDF's, or other sources. They are often merged
cells, and I can do it, but it takes several steps. ie-select all, click
"merge" cells off, then select all, and sort. This often changes the order
of the data, which I don't want to do.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How do I remove all carriage returns from a Word document?

All carriage returns or just extra ones (empty paragraphs)? You can search
for ^p and replace with nothing or search for ^p^p and replace with ^p,
depending on which you want to do.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"guest in calif" guest in wrote in message
...
Does anyone have a quick solution to remove all carriage returns from a
Word
document?

I would also like to know how to remove empty lines in excel that result
when I cut and paste data from PDF's, or other sources. They are often
merged
cells, and I can do it, but it takes several steps. ie-select all, click
"merge" cells off, then select all, and sort. This often changes the
order
of the data, which I don't want to do.



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
guest in calif[_2_] guest in calif[_2_] is offline
external usenet poster
 
Posts: 2
Default How do I remove all carriage returns from a Word document?

Hi Suzanne,

Maybe I'm more of a novice than I thought :-). I'm trying to remove all
extraneous CR's that were found in the body of an email, so that it will read
like a regular letter. I copied the body of the email (from excite.com) into
MS Word, but can't get rid of the CR's w/o going from one line to the next,
deleting the CR manually (ie, w/the backspace key). This takes too much
time. Is there a quick formatting solution?

"Suzanne S. Barnhill" wrote:

All carriage returns or just extra ones (empty paragraphs)? You can search
for ^p and replace with nothing or search for ^p^p and replace with ^p,
depending on which you want to do.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"guest in calif" guest in wrote in message
...
Does anyone have a quick solution to remove all carriage returns from a
Word
document?

I would also like to know how to remove empty lines in excel that result
when I cut and paste data from PDF's, or other sources. They are often
merged
cells, and I can do it, but it takes several steps. ie-select all, click
"merge" cells off, then select all, and sort. This often changes the
order
of the data, which I don't want to do.




  #4   Report Post  
Posted to microsoft.public.word.docmanagement
grammatim[_2_] grammatim[_2_] is offline
external usenet poster
 
Posts: 2,751
Default How do I remove all carriage returns from a Word document?

Find/Replace (Ctrl-H)

Assuming that paragraphs are divided by an extra paragraph mark,

1. In the Find box, type ^p^p

In the Replace box, type ^l (small L)

Click Replace All

2a. (assuming there's a space between the last word on each line and
the paragraph mark)

In the Find box, type ^p

Clear the Replace box entirely

Click Replace All

2b (if there's no space between the last word on each line and the
paragraph mark)

In the Find box, type ^p

In the Replace box, type one space (you won't see anything)

Click Replace All

3. In the Find box, type ^l (small L)

In the Replace box, type ^p

Click Replace All

On Oct 30, 4:16*pm, guest in calif
wrote:
Hi Suzanne,

Maybe I'm more of a novice than I thought :-). *I'm trying to remove all
extraneous CR's that were found in the body of an email, so that it will read
like a regular letter. *I copied the body of the email (from excite.com) into
MS Word, but can't get rid of the CR's w/o going from one line to the next,
deleting the CR manually (ie, w/the backspace key). *This takes too much
time. Is there a quick formatting solution?



"Suzanne S. Barnhill" wrote:
All carriage returns or just extra ones (empty paragraphs)? You can search
for ^p and replace with nothing or search for ^p^p and replace with ^p,
depending on which you want to do.


--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA


"guest in calif" guest in wrote in message
...
Does anyone have a quick solution to remove all carriage returns from a
Word
document?


I would also like to know how to remove empty lines in excel that result
when I cut and paste data from PDF's, or other sources. They are often
merged
cells, and I can do it, but it takes several steps. *ie-select all, click
"merge" cells off, then select all, and sort. *This often changes the
order
of the data, which I don't want to do.-

  #5   Report Post  
Posted to microsoft.public.word.docmanagement
guest in calif[_2_] guest in calif[_2_] is offline
external usenet poster
 
Posts: 2
Default How do I remove all carriage returns from a Word document?

Thanks so much to both of you!!!!

I failed to mention that the search for ^p yielded nothing, since I now know
that it stands for the backwards P that indicates a CR. My data had the
symbol that looks like a backward L w/an arrow on the L side (like what is
printed on the "enter" key)
which evidently (thanks to grammatim reading my mind) also indicates a CR.
I formatted the whole thing in seconds.

Is there a list of such abbreviations anywhere?

--------------------------

"grammatim" wrote:

Find/Replace (Ctrl-H)

Assuming that paragraphs are divided by an extra paragraph mark,

1. In the Find box, type ^p^p

In the Replace box, type ^l (small L)

Click Replace All

2a. (assuming there's a space between the last word on each line and
the paragraph mark)

In the Find box, type ^p

Clear the Replace box entirely

Click Replace All

2b (if there's no space between the last word on each line and the
paragraph mark)

In the Find box, type ^p

In the Replace box, type one space (you won't see anything)

Click Replace All

3. In the Find box, type ^l (small L)

In the Replace box, type ^p

Click Replace All

On Oct 30, 4:16 pm, guest in calif
wrote:
Hi Suzanne,

Maybe I'm more of a novice than I thought :-). I'm trying to remove all
extraneous CR's that were found in the body of an email, so that it will read
like a regular letter. I copied the body of the email (from excite.com) into
MS Word, but can't get rid of the CR's w/o going from one line to the next,
deleting the CR manually (ie, w/the backspace key). This takes too much
time. Is there a quick formatting solution?



"Suzanne S. Barnhill" wrote:
All carriage returns or just extra ones (empty paragraphs)? You can search
for ^p and replace with nothing or search for ^p^p and replace with ^p,
depending on which you want to do.


--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA


"guest in calif" guest in wrote in message
...
Does anyone have a quick solution to remove all carriage returns from a
Word
document?


I would also like to know how to remove empty lines in excel that result
when I cut and paste data from PDF's, or other sources. They are often
merged
cells, and I can do it, but it takes several steps. ie-select all, click
"merge" cells off, then select all, and sort. This often changes the
order
of the data, which I don't want to do.-




  #6   Report Post  
Posted to microsoft.public.word.docmanagement
mt_si_dad[_2_] mt_si_dad[_2_] is offline
external usenet poster
 
Posts: 6
Default How do I remove all carriage returns from a Word document?

In help, search for "Find and replace paragraph breaks, page breaks, and
other items" and scroll down to "Use codes to find letters, formatting,
fields, or special characters"

note that it's lower-case "p" and "l"

A hint that I use -- since it's possible that there are "^l" marks I want to
keep, I do this

1. Find/Replace all doubled "^p" marks with "&&&" (a combination of
characters I'm very unlikely to have in my documents.
2. Find/Replace all single "^p" marks with a single space (so a sentence cut
in half won't have the two wordsjumbled together like that)
3. Find/Replace all "&&&" with "^p^p" (or, if I'm using the default Normal
style in Word 2007, a single "^p", because Word 2007's Normal style has an
automatic extra space after each paragraph.

This is fairly useful, even if it's not perfect -- you'll need to be aware
of text areas such as an e-mail header area where there is only a single line
separating things like the address, subject, and date.

If you select the text area first (highlight it) and *then* use
Find/Replace, it finds/replaces only in the selected text, saving you this
problem.



"guest in calif" wrote:

Thanks so much to both of you!!!!

I failed to mention that the search for ^p yielded nothing, since I now know
that it stands for the backwards P that indicates a CR. My data had the
symbol that looks like a backward L w/an arrow on the L side (like what is
printed on the "enter" key)
which evidently (thanks to grammatim reading my mind) also indicates a CR.
I formatted the whole thing in seconds.

Is there a list of such abbreviations anywhere?

--------------------------

"grammatim" wrote:

Find/Replace (Ctrl-H)

Assuming that paragraphs are divided by an extra paragraph mark,

1. In the Find box, type ^p^p

In the Replace box, type ^l (small L)

Click Replace All

2a. (assuming there's a space between the last word on each line and
the paragraph mark)

In the Find box, type ^p

Clear the Replace box entirely

Click Replace All

2b (if there's no space between the last word on each line and the
paragraph mark)

In the Find box, type ^p

In the Replace box, type one space (you won't see anything)

Click Replace All

3. In the Find box, type ^l (small L)

In the Replace box, type ^p

Click Replace All

On Oct 30, 4:16 pm, guest in calif
wrote:
Hi Suzanne,

Maybe I'm more of a novice than I thought :-). I'm trying to remove all
extraneous CR's that were found in the body of an email, so that it will read
like a regular letter. I copied the body of the email (from excite.com) into
MS Word, but can't get rid of the CR's w/o going from one line to the next,
deleting the CR manually (ie, w/the backspace key). This takes too much
time. Is there a quick formatting solution?



"Suzanne S. Barnhill" wrote:
All carriage returns or just extra ones (empty paragraphs)? You can search
for ^p and replace with nothing or search for ^p^p and replace with ^p,
depending on which you want to do.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"guest in calif" guest in wrote in message
...
Does anyone have a quick solution to remove all carriage returns from a
Word
document?

I would also like to know how to remove empty lines in excel that result
when I cut and paste data from PDF's, or other sources. They are often
merged
cells, and I can do it, but it takes several steps. ie-select all, click
"merge" cells off, then select all, and sort. This often changes the
order
of the data, which I don't want to do.-


  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How do I remove all carriage returns from a Word document?

Ah, in that case what you need is the instructions in
http://word.mvps.org/FAQs/Formatting/CleanWebText.htm. Or automate it with
the macro from http://gregmaxey.mvps.org/Clean_Up_Text.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"guest in calif" wrote in message
news
Hi Suzanne,

Maybe I'm more of a novice than I thought :-). I'm trying to remove all
extraneous CR's that were found in the body of an email, so that it will
read
like a regular letter. I copied the body of the email (from excite.com)
into
MS Word, but can't get rid of the CR's w/o going from one line to the
next,
deleting the CR manually (ie, w/the backspace key). This takes too much
time. Is there a quick formatting solution?

"Suzanne S. Barnhill" wrote:

All carriage returns or just extra ones (empty paragraphs)? You can
search
for ^p and replace with nothing or search for ^p^p and replace with ^p,
depending on which you want to do.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"guest in calif" guest in wrote in
message
...
Does anyone have a quick solution to remove all carriage returns from a
Word
document?

I would also like to know how to remove empty lines in excel that
result
when I cut and paste data from PDF's, or other sources. They are often
merged
cells, and I can do it, but it takes several steps. ie-select all,
click
"merge" cells off, then select all, and sort. This often changes the
order
of the data, which I don't want to do.






  #8   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default How do I remove all carriage returns from a Word document?

If you expand the Replace dialog and click Special, you'll get a list of
special codes you can insert. ^l is a line break (inserted with
Shift+Enter).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"guest in calif" wrote in message
...
Thanks so much to both of you!!!!

I failed to mention that the search for ^p yielded nothing, since I now
know
that it stands for the backwards P that indicates a CR. My data had the
symbol that looks like a backward L w/an arrow on the L side (like what is
printed on the "enter" key)
which evidently (thanks to grammatim reading my mind) also indicates a CR.
I formatted the whole thing in seconds.

Is there a list of such abbreviations anywhere?

--------------------------

"grammatim" wrote:

Find/Replace (Ctrl-H)

Assuming that paragraphs are divided by an extra paragraph mark,

1. In the Find box, type ^p^p

In the Replace box, type ^l (small L)

Click Replace All

2a. (assuming there's a space between the last word on each line and
the paragraph mark)

In the Find box, type ^p

Clear the Replace box entirely

Click Replace All

2b (if there's no space between the last word on each line and the
paragraph mark)

In the Find box, type ^p

In the Replace box, type one space (you won't see anything)

Click Replace All

3. In the Find box, type ^l (small L)

In the Replace box, type ^p

Click Replace All

On Oct 30, 4:16 pm, guest in calif
wrote:
Hi Suzanne,

Maybe I'm more of a novice than I thought :-). I'm trying to remove
all
extraneous CR's that were found in the body of an email, so that it
will read
like a regular letter. I copied the body of the email (from
excite.com) into
MS Word, but can't get rid of the CR's w/o going from one line to the
next,
deleting the CR manually (ie, w/the backspace key). This takes too
much
time. Is there a quick formatting solution?



"Suzanne S. Barnhill" wrote:
All carriage returns or just extra ones (empty paragraphs)? You can
search
for ^p and replace with nothing or search for ^p^p and replace with
^p,
depending on which you want to do.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"guest in calif" guest in wrote in
message
...
Does anyone have a quick solution to remove all carriage returns
from a
Word
document?

I would also like to know how to remove empty lines in excel that
result
when I cut and paste data from PDF's, or other sources. They are
often
merged
cells, and I can do it, but it takes several steps. ie-select all,
click
"merge" cells off, then select all, and sort. This often changes
the
order
of the data, which I don't want to do.-




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
remove hard carriage returns Jackie Allen Microsoft Word Help 2 June 11th 08 02:56 PM
remove carriage returns in a document? HisNameForever Page Layout 1 March 21st 07 12:28 PM
Remove Extra Carriage Returns DandHJohn Microsoft Word Help 3 July 16th 05 02:45 PM
Remove hard carriage returns Rusty Microsoft Word Help 4 March 1st 05 08:10 PM
How do I remove carriage returns in a paragraph... Hitesh Microsoft Word Help 2 December 8th 04 10:17 PM


All times are GMT +1. The time now is 03:13 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"