A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Removing Blank Lines and End of Line Characters in a Word Table



 
 
Thread Tools Display Modes
  #1  
Old September 11th 06, 03:45 PM posted to microsoft.public.word.docmanagement
Dan Thorman
external usenet poster
 
Posts: 1
Default Removing Blank Lines and End of Line Characters in a Word Table

i have a rather large (237 pages) word table that I am attempting to put into
Excel in order to manipulate it. If i copy/paste into Excel and chose to
maintain the formatting, i can get the table to come very close to
maintaining the correct format in order to manipulate it. The problem i
encounter is that in one column of the table in Word there are multiple
sections per cell that are separated with blank lines or RETURNs Thus,
when i copy/paste into excel, the (for example) 3 sections that should make
up one cell get copied into 3 cells. To fix this problem, i am guessing that
I can simply find/replace these blank lines or endline characters with
spaces, thus turning multiple sections into one. How do I do this?

Thanks in advance for your help! (to further the example, this message is
now split into the two sections that I would like to be able to place in one
cell)
Ads
  #2  
Old September 11th 06, 06:27 PM posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
 
Posts: 33,626
Default Removing Blank Lines and End of Line Characters in a Word Table

You can replace paragraph breaks or line breaks, whichever they are, by
typing ^p or ^l (lowercase L) in the "Find what" box. For other special
characters you can search for, click More in the Replace dialog and click
the button for Special.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Dan Thorman" wrote in message
...
i have a rather large (237 pages) word table that I am attempting to put

into
Excel in order to manipulate it. If i copy/paste into Excel and chose to
maintain the formatting, i can get the table to come very close to
maintaining the correct format in order to manipulate it. The problem i
encounter is that in one column of the table in Word there are multiple
sections per cell that are separated with blank lines or RETURNs Thus,
when i copy/paste into excel, the (for example) 3 sections that should

make
up one cell get copied into 3 cells. To fix this problem, i am guessing

that
I can simply find/replace these blank lines or endline characters with
spaces, thus turning multiple sections into one. How do I do this?

Thanks in advance for your help! (to further the example, this message is
now split into the two sections that I would like to be able to place in

one
cell)


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.