NEWLINE function

NEWLINE () NEWLINE ()

Returns

Text Text

A line break character.

Returns a line break character, which causes the character following it to appear on the next line. "First line" & NEWLINE () & "Second line""First line" & NEWLINE () & "Second line" produces the following text:

First line Second line

However, it is often easier to generate a text string containing line breaks simply by using verbatim line breaks. This formula produces the text above:

"First line Second line"

The line break character produced by this function is also known as newline , line feed (LF) , end of line (EOL) and line ending . Its Unicode code point is 10, meaning that these formulas are equivalent:

NEWLINE ()

CHAR (10)

This function is not commonly supported by spreadsheets.

Examples

"A" & NEWLINE () & "B"

Returns "A", followed by a line break, followed by "B".

"A" & CHAR (10) & "B"

Returns "A", followed by a line break, followed by "B". As the line break character returned by NEWLINE corresponds to the Unicode code point 10, it can also be returned through the CHAR function.

"Velocity: " & Velocity & NEWLINE () & "Weight: " & Weight

Returns text incorporating values and line breaks.