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
Space between paragraphs Ask for Help	5	891	May 2, 2020
Formatting Text in Pages Ask for Help	8	293	January 4, 2023
Paragraph spaces within a cell Ask for Help	12	2186	February 14, 2020
Intro and Issue Ask for Help	7	1200	May 25, 2020
=SUBSTITUTE(A1, CHAR(13), " " & CHAR(13)) Excel Formula not Working Ask for Help	12	857	May 20, 2023

Rich text not displaying correctly

Related topics