Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Remove Hard Returns

Topic Labels: Formulas
1566 1
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I create a formula field that references an existing text field, but removes hard returns between lines of type?

1 Reply 1

To remove hard returns, you can use the SUBSTITUTE() function to remove the newline symbol: \n

SUBSTITUTE({Field Name}, "\n", "")

However, if you just remove all newlines, you might want to replace it with something else depending on how you plan on using the modified text.