Results 1 to 13 of 13
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert a Word Document (2003)

    I have an investigation inExcel. I have a statement in Word that I need to paste into a worksheet in Excel. One paragraph in the Word document cuts off because of it's length. Any suggestions on how I can paste or insert this document into Excel and keep the layout. The Word document prints out on two pages.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a Word Document (2003)

    I wouldn't insert a Word document in an Excel worksheet. Or if you really must, copy and paste it in smaller parts.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert a Word Document (2003)

    Yes I agree,
    I got it done by going into word and splitting the monster paragragh into smaller ones-then copying and pasting into Excel -then formatting the cells in Excel
    A chore but all the information is there, thanks for the tip.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a Word Document (2003)

    You can also paste a page from a Word document as a Word object. It'll float above the worksheet.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert a Word Document (2003)

    A related question:
    If you copy a worksheet from one workbook to another, cell contents higher than some number (it may have been 255 characters) are truncated. Is there any way to change this limit or is one forced to copy cell by cell to the new workbook when high character count is involved?

    Paul

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a Word Document (2003)

    There is no need to copy cell by cell. You can select all cells in a worksheet (Ctrl+A), then copy and paste into a worksheet in another workbook. Cells will not be truncated at 255 characters.

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Insert a Word Document (2003)

    The way to get around the limit is to, instead of copying the worksheet, create a blank sheet in the 2nd workbook, then in the source, use Ctrl-A (or choose the intersection of row/column headers) to select all the cells, then copy this and paste it into cell A1 of the blank sheet.

    Steve

  8. #8
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert a Word Document (2003)

    Thanks Steve & Hans !

    Paul

  9. #9
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Insert a Word Document (2003)

    Hi Hans,

    If I am reading this right you can embed a word document in an excel spread sheet?

    how do I do this?

    Thanks

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a Word Document (2003)

    For example:

    Select Insert | Object...
    Activate the 2nd tab.
    Click Browse...
    Select the document and click Insert.
    Back in the Insert Object dialog, specify whether you want to embed or link the document, and whether you want to display it as an icon.
    Finally, click OK.
    The user can double click the inserted object to view the entire document (and to edit it).

    Instead of embedding or linking a document, you can also insert a clickable hyperlink to a document in a cell (Insert | Hyperlink...)

  11. #11
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert a Word Document (2003)

    This highlights one limitation of the current MS Office that we had in an older version which had Binders. I miss being able to group related documents, spreadsheets, and such into a single file. I wish there were a "Binder" functionality in the current (or future) version of MS Office.

  12. #12
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Insert a Word Document (2003)

    thanks Hans

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insert a Word Document (2003)

    It was a nice feature, but I don't think it'll come back...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •