Help

Remove all text after a parentheses

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

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!