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	302	January 4, 2023
Space between paragraphs Ask for Help	5	930	May 2, 2020
Paragraph spaces within a cell Ask for Help	12	2213	February 14, 2020
How do I add line breaks to copy? Project Showcase	3	927	September 15, 2019
Text colour change Ask for Help	5	3974	September 5, 2020

Rich text not displaying correctly

Related topics