- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 18, 2024 04:08 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 18, 2024 04:43 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 18, 2024 04:50 PM
Worked, I had -1. Thanks!
