Results 1 to 5 of 5
  1. #1
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Importing Word Tables (97sr2H)

    I'm trying to import some complex Word97 tables to Excel; many of the cells in the table contain paragrah breaks (
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Importing Word Tables (97sr2H)

    No solution here, but be aware also that the same sort of thing happens if your Word table has line breaks and/or tabs within cells.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Importing Word Tables (97sr2H)

    Since the only way I know to keep the cells intact is to avoid line breaks, maybe you can replace all "^p" with some special character sequence as placeholders in Word. Then after the import, in Excel replace them back to line breaks with another search/replace.
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Importing Word Tables (97sr2H)

    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Importing Word Tables (97sr2H)

    John,

    There have been several threads on this subject. I think there was one in April (see post #129369) where some string was changed in Excel using replace. In December, I posted a macro that would allow you to take a set of Excel cells and replace some string with a line return (equivalent of using ALT+Enter in Excel).

    I don't think there is a way to prevent Excel from messing up a Word table that has hard line returns if you paste that directly from Word to Excel. You have to hide those line returns while in Word and replace whatever you use once you get into Excel. It sounds like you've come down that path.

    Fred

Posting Permissions

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