Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
copy a table from word to excel as cells
I have a table that has been created in Word that i want to copy to Excel.
Specifically I want each cell in the word table to correspond to a single cell in excel. I'm running into a problem where Returns were used to seperate the text in a cell. when this cell goes to excel, the returns result in each line of text being a new excel cell. Versus the ability to use alt-Return in excel to put carriage returns inside a cell for text formatting??? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
copy a table from word to excel as cells
You can use Alt+Enter in Word too. Since you didn't, you can use the
Edit | Replace command in Word to search the table for paragraph marks and replace with line breaks. Greg Middleton wrote: I have a table that has been created in Word that i want to copy to Excel. Specifically I want each cell in the word table to correspond to a single cell in excel. I'm running into a problem where Returns were used to seperate the text in a cell. when this cell goes to excel, the returns result in each line of text being a new excel cell. Versus the ability to use alt-Return in excel to put carriage returns inside a cell for text formatting??? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
copy a table from word to excel as cells
hey im new to google and not sure how to make my own forum thing
please help me im desprate this is what i need help with. All the key things on google such as : web : images :news :maps etc has moved to the top left of my computer screen nothing else just my main searching tools :S please help its soo annoying i really need help Sorry but this has nothing to do about this topic |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
copy a table from word to excel as cells
Being new to Google has nothing to do with the way this newsgroup operates,
and your question has nothing to do with tables in Microsoft Word. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA wrote in message ... hey im new to google and not sure how to make my own forum thing please help me im desprate this is what i need help with. All the key things on google such as : web : images :news :maps etc has moved to the top left of my computer screen nothing else just my main searching tools :S please help its soo annoying i really need help Sorry but this has nothing to do about this topic |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
copy a table from word to excel as cells
That's what I thought, but that doesn't work.
I did Find/replace Paragraph Mark/Manual Line Break. Did a Select on the entire Table and then paste into excel. same result, it splits the Manual Line Breaks into a new row in excel. I'm using Word 2007/Excel 2007; sp1 "garfield-n-odie [MVP]" wrote: You can use Alt+Enter in Word too. Since you didn't, you can use the Edit | Replace command in Word to search the table for paragraph marks and replace with line breaks. Greg Middleton wrote: I have a table that has been created in Word that i want to copy to Excel. Specifically I want each cell in the word table to correspond to a single cell in excel. I'm running into a problem where Returns were used to seperate the text in a cell. when this cell goes to excel, the returns result in each line of text being a new excel cell. Versus the ability to use alt-Return in excel to put carriage returns inside a cell for text formatting??? |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
copy a table from word to excel as cells
how do i make my own group thing then...
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table cells: preserving font and color during Copy & Paste. | Microsoft Word Help | |||
How copy row cells of one table to another? | Microsoft Word Help | |||
want cells in a table to copy data from cells in another table | Tables | |||
Slanted cells in top row of Word table or Excel spreadsheet? | Page Layout | |||
If I insert an Excel table I get a graph, not the cells I specifie | Tables |