Transfer data only from Excel spreadsheetinto Word or text document

[Dave_in_Tucson]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)

I have to move the data only that is in an Excel spreadsheet into a Word or text document so that I can edit the info into a paragraph style for a book. What's the easiest way to do this?

 

[CyberTaz]

There are several ways, but to make a responsible suggestion would require
much more information about the amount & nature of the data as well as what
else is in the file other than the "data only". Investigate the following:

a) File> Save As, then open the Format: list in the middle of the dialog
window,

b) Copy in Excel then look at the File> Paste Special options available in
Word.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[qryn]

You can also paste the tabel into Word and then choose from the top menu: Table > Convert > Convert table to text. You can choose the options of you liking in the following dialoge.

Good luck.

 

[Dave_in_Tucson]

You can also paste the tabel into Word and then choose from the top menu: Table > Convert > Convert table to text. You can choose the options of you liking in the following dialoge.

Good luck.

Thanks. That worked out fine