
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 27, 2023 06:39 AM
I have a column that has a list of counties and they all have the state abbreviations next to them. Is there a way to remove the abbreviations with a formula inside of airtable?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 27, 2023 08:12 AM
Is there a seperator of some sort? If there is you can use it with LEFT() and FIND() like so:
LEFT(
Name,
FIND(
" - ",
Name
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 27, 2023 01:58 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 27, 2023 08:12 AM
Is there a seperator of some sort? If there is you can use it with LEFT() and FIND() like so:
LEFT(
Name,
FIND(
" - ",
Name
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 27, 2023 08:32 AM
Thank you! It does have a separating character it is a comma. It is formatted like this.
South Dakoda, US
Ohio, Us etc
I tried your formula and it leaves the comma in the text box. Is there a way to fix this?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 27, 2023 01:58 PM
I fixed it all I did was add a "-1" to the formula
