=SUBSTITUTE(A1, CHAR(13), " " & CHAR(13)) Excel Formula not Working

[johnmuir]

Hello fellow gliders,

I am trying to add a line break to a rich text column but when I add this excel formula column it does not return any data.

The text that I want substituted is in the A1 column. Not sure why this is not working. Any help would be greatly appreciated. Thank you

[Uzo]

Glide does not support the SUBSTITUTE formula… use the template column… <br>

[johnmuir]

Thank you for your speedy response. That is good to know, I assumed SUBSTITUTE was supported.

If you don’t mind, how would you set up the template column? I tried and the replacement field does not appear to recognize Char(13). Or at least the data does not appear to change when displayed on the FE.

[Uzo]

Do you want to replace char 13 with space?

[johnmuir]

Actually the other way around. Basically when the user enters rich text like so:

One item 
two item 
three item 
four item

it is displayed as so:

one item two item three item four item

and I would prefer it to be displayed as it is entered (top)

[Uzo]

use rich text component to display it

[johnmuir]

Rich text component still displays it as:

one item two item three item four item

[Uzo]

i’m lost… rich text will display with line breaks… use double break or tag <br>

[johnmuir]

That is what I am so confused about. It is displaying it in different ways in the glide table and on the FE. As seen below

[Uzo]

[Jeff_Hager]

Try typing a Carriage Return (Enter key) into the ‘Replace This’ parameter.

Then there are a few things you can try in the ‘With This’ parameter:

• 2 spaces and a carriage return
• <br>
• <p>

One of those should work.

[johnmuir]

Using the Replace All column and typing the carriage return (enter key) in the ‘replace this’ parameter and the <br> in the ‘with this’ parameter worked.

Thank you so much for the help, @Uzo and @Jeff_Hager.