Remove Hard Returns

Topic Labels: Formulas
1140 1
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.