Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replacing paragraph marks (97)

    How can I replace hard returns with soft returns (shift enter) in a document? Thanks, Andy.

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

    Re: Replacing paragraph marks (97)

    Open the Replace dialog (Ctrl+H)
    Enter ^p in the "Find what" box.
    Enter ^l (that is a lower case L) in the "Replace with" box.

    There is a Special button in the dialog that displays a popup list of special characters you can use in Find and Replace. I don't remember whether you had to click More first in Word 97 (you have to in Word 2002.)

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing paragraph marks (97)

    Thanks, that works fine. However, I wanted to move the data into an Access 97 Database, but Access doesn't like these 'soft returns'. I know that Access uses ctrl-enter?! Any ideas how I can get an address field from word into Access, keeping the return characters? Andy.

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

    Re: Replacing paragraph marks (97)

    In general, I try to avoid multi-line address fields in Access. I would import the addresses as a series of separate fields (one per line) into Access. For reporting purposes, you can concatenate them again with Chr(13) & Chr(10) in between.

  5. #5
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing paragraph marks (97)

    I agree, however.. there are thousands of existing records to be imported from word tables.. So any idea how I can retain the paragraphs in Access? Thank you

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

    Re: Replacing paragraph marks (97)

    If each address has the same number of lines, you can do this:
    - Replace paragraph marks ^p by tabs ^t
    - Select Table | Convert Table to Text...
    - Select Tab as separator, and click OK.
    - Select Table | Convert Text to Table
    - Select Tab as separator and click OK.
    You should now have a table with a column for each line of the original address.

    If the number of lines varies, you could still do this, then copy the table into Excel and edit it, finally import the Excel table into Access.

    Unless I'm overlooking something simple, the alternative would be to write code to import the Word tables. Not very attractive.

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing paragraph marks (97)

    Hi Hans:
    I'm curious. I'm not that familiar with Excel, although I do use it. Why did you suggest copying the table into Excel for editing, rather than editing directly within Word?
    Thanks,

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

    Re: Replacing paragraph marks (97)

    If you have a table with addresses with a varying number of lines per cell, and convert this to a table where each line is a separate cell, you'll probably end up with shifting columns, so you'll have to do some moving around of cells to get it right:

    <table border=1><td>Anne Richards</td><td>Amalgamated Synergistics</td><td>12, Webber Court</td><td>Phoenix</td><td>Arizona</td><tr><td>Jim Beard</td><td>60 Richardson Road</td><td>Kensington</td><td>California</td><td align=right>

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing paragraph marks (97)

    Thanks, Hans. No, it's probably due to my lack of experience in Excel. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

Posting Permissions

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