Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replace placeholder with 'alt-enter' (2000)

    I am trying to convert a word table (with some cells that have multiple lines)into excel. Natively, excel will resolve this by placing each line from word into a separate row in Excel. This, of course, adds useless rows, making it difficult to sort.
    I've replaced all line breaks within a word table cell with ***. Now, I'd like to be able to replace the *** with "alt-enter" (I tried it with a hard space too)
    Generally, I avoid using Excel for documents with a lot of text, but there are over 1500 records and so sorting in Word is veeeeeery slow. Also, it's for an attorney who won't hear any other option!
    Any ideas?
    Thanks!

  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: Replace placeholder with 'alt-enter' (2000)

    Select the range
    Edit -replace
    Find what:
    ~*~*~*
    replace with
    while hold <alt> key, enter 0010 from numeric keypad
    <replace all>

    Steve

  3. #3
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replace placeholder with 'alt-enter' (2000)

    Thanks Steve!
    I'd tried the alt + 0010 to no avail, then realized that nothing actually appears in the "replace with" box.
    When I hit "replace", it worked!!!
    Incidentally, I needed a final ~ after the last **.
    Thanks so much!

  4. #4
    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: Replace placeholder with 'alt-enter' (2000)

    <alt>0010 puts in the "linefeed" char (like Alt-enter). If you had put something in the replace you would have noticed you are now on the "next line" of the cell: it only looks like it did nothing.

    I don't understand why you would need a final ~ (though as long as it works...). You should only need a tilde (~) before each asterisk (*), to tell excel that you want the "literal asterisk" rather than the "wild card asterisk" (which indicates "all chars").

    Steve

Posting Permissions

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