What is the character code for new line break in excel

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

2 Answers

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

Try using the [Alt] + [Enter] key. This will create a new line feed in the cell.