excelexcel-formulaexcel-2007line-breaks

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


Solution

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