Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
delete all section marks in a Word Table
I have a table that is sent to me in a word document. I need to move it into
Excel, but the person who creates it presses enter in the middle of the data to line feed the information into a pretty format. If I put the data into text everything comes out with line feeds in the middle of data groups. In Excel Some of the cells come out on one row others slip to a second row because of the hidden blank cells caused by section marks. Can these marks be stripped out of the whole file? Any ideas? See below an example of what it looks like when I convert to text. Mary James 1/2/45 To 1/6/87 This is the way the file looks John Smith 1/7/62 - 1/8/92 Or it May look Like this |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
delete all section marks in a Word Table
Well, these are not section breaks, just line breaks. You can remove manual
line breaks in Word by searching for ^l (lowercase L) and replacing with nothing or a space as appropriate. -- 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. "PatT123" wrote in message ... I have a table that is sent to me in a word document. I need to move it into Excel, but the person who creates it presses enter in the middle of the data to line feed the information into a pretty format. If I put the data into text everything comes out with line feeds in the middle of data groups. In Excel Some of the cells come out on one row others slip to a second row because of the hidden blank cells caused by section marks. Can these marks be stripped out of the whole file? Any ideas? See below an example of what it looks like when I convert to text. Mary James 1/2/45 To 1/6/87 This is the way the file looks John Smith 1/7/62 - 1/8/92 Or it May look Like this |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
delete all section marks in a Word Table
Did you mean a physical above the #6 and an l or is an alt or control and an
l. I tried the above the 6 and it did not work. "Suzanne S. Barnhill" wrote: Well, these are not section breaks, just line breaks. You can remove manual line breaks in Word by searching for ^l (lowercase L) and replacing with nothing or a space as appropriate. -- 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. "PatT123" wrote in message ... I have a table that is sent to me in a word document. I need to move it into Excel, but the person who creates it presses enter in the middle of the data to line feed the information into a pretty format. If I put the data into text everything comes out with line feeds in the middle of data groups. In Excel Some of the cells come out on one row others slip to a second row because of the hidden blank cells caused by section marks. Can these marks be stripped out of the whole file? Any ideas? See below an example of what it looks like when I convert to text. Mary James 1/2/45 To 1/6/87 This is the way the file looks John Smith 1/7/62 - 1/8/92 Or it May look Like this |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
delete all section marks in a Word Table
The ^ above the 6. If you click "More" in the Find and Replace dialog and
click on Special, then Manual Line Break, Word will insert this code for you. If this is not finding line breaks, then perhaps they are not line breaks but paragraph breaks (^p). See http://word.mvps.org/FAQs/Formatting/NonPrintChars.htm -- 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. "PatT123" wrote in message ... Did you mean a physical above the #6 and an l or is an alt or control and an l. I tried the above the 6 and it did not work. "Suzanne S. Barnhill" wrote: Well, these are not section breaks, just line breaks. You can remove manual line breaks in Word by searching for ^l (lowercase L) and replacing with nothing or a space as appropriate. -- 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. "PatT123" wrote in message ... I have a table that is sent to me in a word document. I need to move it into Excel, but the person who creates it presses enter in the middle of the data to line feed the information into a pretty format. If I put the data into text everything comes out with line feeds in the middle of data groups. In Excel Some of the cells come out on one row others slip to a second row because of the hidden blank cells caused by section marks. Can these marks be stripped out of the whole file? Any ideas? See below an example of what it looks like when I convert to text. Mary James 1/2/45 To 1/6/87 This is the way the file looks John Smith 1/7/62 - 1/8/92 Or it May look Like this |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
delete all section marks in a Word Table
Thank you my world has opened wider thanks to MORE on the find form!
"Suzanne S. Barnhill" wrote: The ^ above the 6. If you click "More" in the Find and Replace dialog and click on Special, then Manual Line Break, Word will insert this code for you. If this is not finding line breaks, then perhaps they are not line breaks but paragraph breaks (^p). See http://word.mvps.org/FAQs/Formatting/NonPrintChars.htm -- 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. "PatT123" wrote in message ... Did you mean a physical above the #6 and an l or is an alt or control and an l. I tried the above the 6 and it did not work. "Suzanne S. Barnhill" wrote: Well, these are not section breaks, just line breaks. You can remove manual line breaks in Word by searching for ^l (lowercase L) and replacing with nothing or a space as appropriate. -- 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. "PatT123" wrote in message ... I have a table that is sent to me in a word document. I need to move it into Excel, but the person who creates it presses enter in the middle of the data to line feed the information into a pretty format. If I put the data into text everything comes out with line feeds in the middle of data groups. In Excel Some of the cells come out on one row others slip to a second row because of the hidden blank cells caused by section marks. Can these marks be stripped out of the whole file? Any ideas? See below an example of what it looks like when I convert to text. Mary James 1/2/45 To 1/6/87 This is the way the file looks John Smith 1/7/62 - 1/8/92 Or it May look Like this |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The WordPerfect "Reveal Codes" method is so much easier to use. | Microsoft Word Help | |||
Delete section breaks at end of word document | Page Layout | |||
How do I create a Word form like corel WP merge documents? | Microsoft Word Help | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
is word perfect compatible with office word? | Microsoft Word Help |