Help

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

How to remove specific word (long rich text field type with multiple lines)

Topic Labels: Formulas
399 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Screenshot 2022-01-15 at 12.37.50
Need to remove word ‘Keyword’ from field ‘formula test’.

I would like to have a separate column (Mostly a formula column) that would give me output with no word ‘Keyword’ in the list.

4 Replies 4

Have you tried SUBSTITUTE()?

I found the solution.
Thanks for responding.

Using substitute only
But I didn’t had to create a formula (i don’t know how to). I found a few on the internet that I applied to other columns and somehow my problem got solved.