Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Remove all text after a parentheses

Topic Labels: Formulas
312 2
cancel
Showing results for 
Search instead for 
Did you mean: 
samstackbrick
4 - Data Explorer
4 - Data Explorer

Can you help me with a formula to remove all characters including and after the "(" in Los Angeles (hollywood)?

So my goal is to make Los Angeles (hollywood) --> Los Angeles

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Here's the formula you would use. This formula also checks to make sure that there is a left parenthesis. If not, it just returns the whole field:

 
IF(
FIND("(",{Your Text Field}),
LEFT({Your Text Field},FIND("(",{Your Text Field})-2),
{Your Text Field}
)

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Worked, I had -1. Thanks!