Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I convert a WORD document to an EXCEL spreadsheet?
I am trying to just do this by cutting and pasting and Excel is reformating
into different columns, etc. Isn't their an easier way to do this? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I convert a WORD document to an EXCEL spreadsheet?
When you move Word data to Excel, Excel treats paragraph marks as an
indication for a new cell. So, before you cut and paste, you will have to get rid of the paragraph marks. To avoid messing up the Word document itself, you could copy the data to a blank Word document, then delete the paragraph marks--or replace them with end-of-line marks. If the Word data are not already in a table, it will work better if you convert into one. "Beth Burger" Beth wrote in message ... I am trying to just do this by cutting and pasting and Excel is reformating into different columns, etc. Isn't their an easier way to do this? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I convert a WORD document to an EXCEL spreadsheet?
FWIW, Excel will split cells at line breaks, too. Better to replace
paragraph breaks with something like @@, then search for those in Excel and replace with paragraph breaks. -- 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. "Richard O. Neville" wrote in message hlink.net... When you move Word data to Excel, Excel treats paragraph marks as an indication for a new cell. So, before you cut and paste, you will have to get rid of the paragraph marks. To avoid messing up the Word document itself, you could copy the data to a blank Word document, then delete the paragraph marks--or replace them with end-of-line marks. If the Word data are not already in a table, it will work better if you convert into one. "Beth Burger" Beth wrote in message ... I am trying to just do this by cutting and pasting and Excel is reformating into different columns, etc. Isn't their an easier way to do this? |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I convert a WORD document to an EXCEL spreadsheet?
"Beth Burger" wrote: I am trying to just do this by cutting and pasting and Excel is reformating into different columns, etc. Isn't their an easier way to do this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help | |||
Word applies direct format on File open | Microsoft Word Help | |||
Envelope Address | New Users | |||
Excel worksheet in Word linked text boxes | Page Layout |