Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word to Excel (ExcelXP)

    Is there a way to successfully convert a word document into excel? I can copy and paste and the table that was in word comes out correctly but the rest of the formatting is all over the place. I don't think it can be done but wanted to check here for pearls of wisdom.

  2. #2
    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: Word to Excel (ExcelXP)

    Could you be more specific about "convert". How do you want the TEXT string brought into what are essentially tables in excel. Each word in a separate cell with each row a separate paragragh? Each sentence in a separate cell, each paragraph in a row? Each paragraph in a cell?

    Do you want a picture of the word document? A link to the word document. All sorts of variants, some work okay, some not. Sometimes it works best to just hyperlink to the word doc so you can use the WORD features. Word is a much better word process than excel is.

    Steve

  3. #3
    Star Lounger
    Join Date
    Dec 2002
    Location
    New Orleans, Louisiana, USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word to Excel (ExcelXP)

    My supervisor is the one who wants this. She thinks that the heading centered in Word should appear in a cell in Excel centered just right. The table isn't a problem, it's just all her stuff in the header and footer.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word to Excel (ExcelXP)

    I think if your boss really wants the table in Excel, with headers and footers in place, she'll have to create the header and footer manually.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Word to Excel (ExcelXP)

    Hi Laura,

    You may be able to get the Table header and footer centered the way you boss wants them by formatting them as 'center across selection' or by merging the cells across the required header and footer widths and centering them. The latter approach also allows the header and footer text to be wrapped.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  6. #6
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word to Excel (ExcelXP)

    I create a lot of tables in XL that end up in Word so I tend to leave the job of fancy formatting column headings to Word. However I do put headings on all my XL tables. Check out the various cell alignment options in Format | Cells. I'm with Maropod and his suggestion of using 'center across selection' to get simple column headings across several columns but I'd stay well away from merging cells. I've always found that once cells are merged it becomes a pain to select individual columns and resize them.

    (not) stuck

Posting Permissions

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