Insert a new line with a formula in an excel report

In some of my reports, I like to put a general comment that it is always the same during many months. And for that, for a better structure, I put my sentences in different lines.

formula excel


When I use the formula ?

For a general comment that I will use every month.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".

Don’t forget to active the “wrap text” option, if not, it will appear in 1 single line only.

formula excel


How is the formula ?


Put this formula:

="please dontforget"&CHAR(10)&"to update the line"

Interesting Management