Remove Hard Returns

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.