What is the character code for new line break in excel

Question

I tried char(10) and char(13) but they don`t work by me. I use Excel 2007 and my task is to replace new lines with intervals

Answer 1

Use CHAR(10) and Turn on Wrap Text option. It should work.