Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2001
    Location
    Virginia, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word 97 Table in Excel 97 (Word 97 SR-2)

    We have a user that created a table of data in Word 97. He used hard returns (paragraphs) to separate text within cells. When trying to transfer this data to
    Excel 97 each hard return causes a new row to be created instead of separate paragraphs within a cell. To work around this the user used an @ symbol to
    separate the paragraphs in Word and then transferred the data to Excel. The transfer worked as desired by keeping the separate paragraphs within the same
    cell but now there are thousands of @ symbols that he wants to replace with a hard return or ALT-Enter within Excel. Using the Replace function with the
    paragraph symbol

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Word 97 Table in Excel 97 (Word 97 SR-2)

    I have to admit I've just tried everything I can think of and haven't come up with anything!

    However, is there a reason why each paragraph can't be in a separate cell? If your user set the original Word table up that way he/she could then just pull it in and add/remove cell borders if necessary to make it look like it is in the same cell ... ?
    Beryl M


  3. #3
    BAM
    Guest

    Re: Word 97 Table in Excel 97 (Word 97 SR-2)

    Hi rhitzeroth,

    You figured out the hardest part. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    In the Replace text box in Excel, press <Alt> 010 (Use 10 key pad)
    ~~~~~~~~~~~
    Cheers! <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  4. #4
    New Lounger
    Join Date
    Mar 2001
    Location
    Virginia, USA
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word 97 Table in Excel 97 (Word 97 SR-2)

    BAM,

    Thanks a lot. I think this is going to work but haven't heard from user yet. Where in the heck do you find something like this? Is this a basic set of keystrokes from the days of DOS that I never learned?

  5. #5
    BAM
    Guest

    Re: Word 97 Table in Excel 97 (Word 97 SR-2)

    Hi Ryan,

    <<Is this a basic set of keystrokes from the days of DOS that I never learned?>>

    I take it you never had to create graphics using DOS? <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    It's part of the ASCII (American Standard Code for Information Interchange) character set. Character 10 denotes a line feed, which similar to pressing <Alt Enter> in Excel. Although if you copy/paste it back into Word it is converted into a paragraph mark.

    Actually as of Word 97 it would be part of the Unicode character set (the international standard character set which allows for 65,535 character mappings), but Unicode uses the same 127 characters as the ANSI character set, which is the same first 127 characters of the ASCII character set.... which is part of the reason Word documents are larger than they have been in the past. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Also note that you made need to restart Excel to clear the Replace text box or the code can remain and start 'doubling'up' during consecutive replace actions.
    ~~~~~~~~~~~~
    Cheers! <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

Posting Permissions

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