Remove all text after a parentheses

+2

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

This topic has been closed for replies.

+35

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

+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!

Sign up