Results 1 to 4 of 4
  1. #1
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Find & Replace (all)

    We have some text files that have either a LF or a CR/LF iserted incorrectly.
    What do I put in the find box to search for these, I have tried alt-m, char(10), chr(10), but these are not recognised.
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>
    Paul Coyle
    Approach love and cooking with reckless abandon

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find & Replace (all)

    Paul

    Try typing the ASCII code {Alt}010 using the numeric keypad

    Note - this must be the numeric keypad and NOT the numbers above the letters
    that is, hold Alt down, and type the numeric keypad numbers 0 1 0 and release Alt

  3. #3
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Find & Replace (all)

    Thanks Andrew, I couldn't recall for the life of me how this worked.
    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>
    Paul Coyle
    Approach love and cooking with reckless abandon

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find & Replace (all)

    AN unknown keybaord shortcut is using control-letter combinations:

    ctrl-a = alt 001
    ctrl-b= alt-002
    ..
    ctrl-j = alt 010
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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