Line break in text formula

[RainbowFuckinBrite]

How do you write a line break into a text formula?

[Kiran_Angara]

Hi @RainbowFuckinBrite,

We can do it by using char(10) formula
Example:
=CONCATENATE(“New”,char(10),“Line”)
However, there is a minor UI glitch for adding a line break in the product, which we are tracking as defect #2637.
Will update here once the issue is fixed.

Apply text wrap styling to the Cell/Column where ever we are writing the formula
Please find the attached screenshot for further reference.

Thanks.

[RainbowFuckinBrite]

Ok I’ll try that, thank you!!