top of page

CHAR(10)

Related

Line Break/Line Feed

User cannot simply type a line break or Line Feed in the formula like a usual character, and therefore a special CHAR function is needed to supply the corresponding ASCII code to the concatenation formula

Syntax

&

CONCAT

TEXTJOIN

CHAR(10)

Note

  • On Windows, use CHAR(10) where 10 is the ASCII code for Line feed.​

​

  •   On the Mac system, use CHAR(13) where 13 is the ASCII code for Carriage return.

Char(10).png

e.g.

bottom of page