Skip to main content

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

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.


Reply