Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Remove Hard Returns

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