How can I create a formula field that references an existing text field, but removes hard returns between lines of type?
Remove Hard Returns
+21To 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.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.