ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   COPY & PASTE WORD Doc into EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/53619-copy-paste-word-doc-into-excel.html)

cynjor312

COPY & PASTE WORD Doc into EXCEL
 
I copied and pasted ou remployment app which is in Word 2000 and pasted it in
Excel. The document contains tables. Do i need to take the text out of the
tables before copying and pasting? What steps do i need to take?

Bryan Hessey

COPY & PASTE WORD Doc into EXCEL
 

I usually just copy tables from Word to Excel, and then remove the
Borders as setup.

That you are asking this question would seem to indicate yours did not
copy well, thus I would point out to you that Word is a processor of
text with some arithmetic capability, and Excel a processor of numbers
with some text capability.

To simply copy and paste a document with Styles and paragraphs of long
text will be unlikey to produce a similar look in Excel with it's size,
display and print limitations.

Was there a purpose to this copy? - and has that purpose been achieved,
or could you be more specific about any errors encountered.


cynjor312 Wrote:
I copied and pasted ou remployment app which is in Word 2000 and pasted
it in
Excel. The document contains tables. Do i need to take the text out of
the
tables before copying and pasting? What steps do i need to take?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=481980


cynjor312

COPY & PASTE WORD Doc into EXCEL
 
well i am a beginner in excel and a friend of mine suggested this method so i
tried it. What i notice is there are lines that go way across the page that
look as if they've been bolded. i've tried deleting them but they wont go
anywhere. you say at setup you remove the borders, what's your procedure?

"Bryan Hessey" wrote:


I usually just copy tables from Word to Excel, and then remove the
Borders as setup.

That you are asking this question would seem to indicate yours did not
copy well, thus I would point out to you that Word is a processor of
text with some arithmetic capability, and Excel a processor of numbers
with some text capability.

To simply copy and paste a document with Styles and paragraphs of long
text will be unlikey to produce a similar look in Excel with it's size,
display and print limitations.

Was there a purpose to this copy? - and has that purpose been achieved,
or could you be more specific about any errors encountered.


cynjor312 Wrote:
I copied and pasted ou remployment app which is in Word 2000 and pasted
it in
Excel. The document contains tables. Do i need to take the text out of
the
tables before copying and pasting? What steps do i need to take?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=481980



Bryan Hessey

COPY & PASTE WORD Doc into EXCEL
 

To remove those 'bold' lines, select the rows that have the lines, then
right-mouse - Format Cells, - Border - and remove all borders that you
do not require.



cynjor312 Wrote:
well i am a beginner in excel and a friend of mine suggested this method
so i
tried it. What i notice is there are lines that go way across the page
that
look as if they've been bolded. i've tried deleting them but they wont
go
anywhere. you say at setup you remove the borders, what's your
procedure?

"Bryan Hessey" wrote:


I usually just copy tables from Word to Excel, and then remove the
Borders as setup.

That you are asking this question would seem to indicate yours did

not
copy well, thus I would point out to you that Word is a processor of
text with some arithmetic capability, and Excel a processor of

numbers
with some text capability.

To simply copy and paste a document with Styles and paragraphs of

long
text will be unlikey to produce a similar look in Excel with it's

size,
display and print limitations.

Was there a purpose to this copy? - and has that purpose been

achieved,
or could you be more specific about any errors encountered.


cynjor312 Wrote:
I copied and pasted ou remployment app which is in Word 2000 and

pasted
it in
Excel. The document contains tables. Do i need to take the text

out of
the
tables before copying and pasting? What steps do i need to take?



--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:

http://www.excelforum.com/member.php...o&userid=21059
View this thread:

http://www.excelforum.com/showthread...hreadid=481980




--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=481980



All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com