Results 1 to 4 of 4

Find & Replace with a newline

This is a discussion on Find & Replace with a newline within the Excel Questions forums, part of the Question Forums category; Hi, I want to replace -- with a newline I do ctrl H to get into find and replace but ...

  1. #1
    New Member
    Join Date
    Oct 2002
    Posts
    8

    Default Find & Replace with a newline

    Hi,

    I want to replace -- with a newline

    I do ctrl H to get into find and replace but the trouble is I dont know the special command for a newline?

    usually it is ^P or /r/n etc

    Thx

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    64,517

    Default

    In the Replace with box hold down Alt and type 010 on the numeric keypad.

  3. #3
    New Member
    Join Date
    Oct 2002
    Posts
    8

    Default

    Perfect

    Thats works like a treat so I can use any ASCII codes to imply a charachter also - or does excel have its own set that i need to look up?

    Thx

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    64,517

    Default

    Excel uses standard ASCII characters.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com