Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    Australia
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Convert Word Tables (Excel 97)

    At work I have inherited some large Word 97 tables which I need to convert to Excel 97. Not usually a problem even for a novice like me, but it is not working. In Word, some cells have multiple lines of data within the cell, with a return (Enter) at the end of each line (within the cell). On conversion in Excel this seems to have the effect of starting a new row each time a return is encountered ( just like the end of row marker from the Word table). Is there a way to convert so that these multiple lines of data in a single cell from Word with a return at the end of each line become multiple lines within a single cell in Excel? Or close to it ? Any help much appreciated.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Convert Word Tables (Excel 97)

    Try using Paste Special, and select Text. This will however result in the loss of the hard CR, which can be replaced manually unless there is too large a number of them. Excel 97 does not handle text pasting as well as Excel 2000.

    Andrew C

  3. #3
    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: Convert Word Tables (Excel 97)


Posting Permissions

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