James said:
I want to move data from an Excel sheet to a Word document but do not
want the data in cells/table. Is it possible to clear Excel contents
and then place in a Word document using the paste function?
Thanks for any assistance
In Office jargon, "clear" = "delete". I don't think that's what you
wanted -- you'd wind up pasting nothing.
You can *copy* a selected group of cells from Excel and paste into Word,
where the result will appear as a table (unless you use the Insert > Object
dialog and choose to insert an Excel object, i.e., a piece of the
spreadsheet embedded in the Word document, which is even further from what
you want).
After you have the table in Word, you can use the command Table > Convert >
Table to Text. That will convert the table structure into a series of
paragraphs, one per row, with the former columns separated by tabs (or
spaces, or whatever you choose in the dialog).
--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
