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	738	May 2, 2020
Formatting Text in Pages Ask for Help	8	232	January 4, 2023
Intro and Issue Ask for Help	7	1082	May 25, 2020
=SUBSTITUTE(A1, CHAR(13), " " & CHAR(13)) Excel Formula not Working Ask for Help	12	549	May 20, 2023
How to structure text Ask for Help	13	569	January 17, 2024

Rich text not displaying correctly

Related Topics