# =SUBSTITUTE(A1, CHAR(13), " " & CHAR(13)) Excel Formula not Working **URL:** \ **Category:** Ask for Help\ **Created:** [May 19, 2023, 7:04pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923 "2023-05-19T19:04:48Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![johnmuir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johnmuir/32/59185_2.png) [@johnmuir](https://community.glideapps.com/u/johnmuir)\ **Post date:** [May 19, 2023, 7:04pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/1 "2023-05-19T19:04:48Z")
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 ![Screen Shot 2023-05-19 at 3.16.27 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/052e0573eb98ce0c9c9b385d2c089f4286e877e9.jpeg) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 19, 2023, 7:22pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/2 "2023-05-19T19:22:51Z")
Glide does not support the SUBSTITUTE formula… use the template column… `
` ---
**Author:** ![johnmuir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johnmuir/32/59185_2.png) [@johnmuir](https://community.glideapps.com/u/johnmuir)\ **Post date:** [May 19, 2023, 7:37pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/3 "2023-05-19T19:37:27Z")
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. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 19, 2023, 7:39pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/4 "2023-05-19T19:39:48Z")
Do you want to replace char 13 with space? ![Screen Shot 2023-05-19 at 9.43.08 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8cb6cd6f870778e820cf8d79a141551c523b921.png) ---
**Author:** ![johnmuir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johnmuir/32/59185_2.png) [@johnmuir](https://community.glideapps.com/u/johnmuir)\ **Post date:** [May 19, 2023, 7:44pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/5 "2023-05-19T19:44:14Z")
Actually the other way around. Basically when the user enters rich text like so: ```auto 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) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 19, 2023, 7:45pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/6 "2023-05-19T19:45:45Z")
use rich text component to display it ---
**Author:** ![johnmuir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johnmuir/32/59185_2.png) [@johnmuir](https://community.glideapps.com/u/johnmuir)\ **Post date:** [May 19, 2023, 7:46pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/7 "2023-05-19T19:46:18Z")
Rich text component still displays it as: `one item two item three item four item` ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 19, 2023, 7:47pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/8 "2023-05-19T19:47:11Z")
i’m lost… rich text will display with line breaks… use double break or tag `
` ---
**Author:** ![johnmuir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johnmuir/32/59185_2.png) [@johnmuir](https://community.glideapps.com/u/johnmuir)\ **Post date:** [May 19, 2023, 7:49pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/9 "2023-05-19T19:49:38Z")
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 ![Screen Shot 2023-05-19 at 3.48.16 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/54f6da4b2230d7c6d2c387ab61dd0e87d79dd29c.png) ![Screen Shot 2023-05-19 at 3.48.29 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/9/b96ff099dcf1ae9ae34b453343ec4765eae75125.jpeg) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 19, 2023, 7:50pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/10 "2023-05-19T19:50:12Z")
![Screen Shot 2023-05-19 at 9.49.55 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0a4c15ea451fd1b7ff8d95d07979d1964f4921f.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 19, 2023, 7:53pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/11 "2023-05-19T19:53:30Z")
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 - `
` - `

` One of those should work. ---

**Author:** ![johnmuir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johnmuir/32/59185_2.png) [@johnmuir](https://community.glideapps.com/u/johnmuir)\ **Post date:** [May 19, 2023, 8:00pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/12 "2023-05-19T20:00:35Z")
Using the Replace All column and typing the carriage return (enter key) in the ‘replace this’ parameter and the `
` in the ‘with this’ parameter worked. Thank you so much for the help, @Uzo and @Jeff_Hager. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 20, 2023, 8:01pm UTC](https://community.glideapps.com/t/substitute-a1-char-13-char-13-excel-formula-not-working/61923/13 "2023-05-20T20:01:15Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.