Find & Replace with a newline

[iwarner]

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

 

[Andrew Poulsom]

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

 

[iwarner]

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

 

[Andrew Poulsom]

Excel uses standard ASCII characters.