I have a form with a notes entry component. Having trouble getting the text to be formatted with line breaks when output as rich text. As you can see below, there are no line breaks. If formatted as entered it should appear as Monday - school Tuesday - family Thursday - school Friday - family A…

@gila . You could add those spaces at the end of each line by creating another column and using this formula (assuming the entered data is in column A): =SUBSTITUTE(A2, CHAR(10), " " & CHAR(10))

Rich text not displaying correctly

Ask for Help

gila February 24, 2020, 7:44am 7

@George_B thank you again!

Formatting tips?

Topic		Replies	Views
Formatting Text in Pages Ask for Help	8	296	January 4, 2023
Add a CR in a text or richtext field, and display it Ask for Help	15	49	February 8, 2025
Wrong Linebreaks / Newlines Report a Bug	5	198	April 21, 2024
Space between paragraphs Ask for Help	5	922	May 2, 2020
Paragraph spaces within a cell Ask for Help	12	2200	February 14, 2020

Rich text not displaying correctly

Related topics