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.

Removing an abbreviation from records

Topic Labels: Formulas
Solved
Jump to Solution
1717 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Nathan_Ramey
6 - Interface Innovator
6 - Interface Innovator

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? 

2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Is there a seperator of some sort?  If there is you can use it with LEFT() and FIND() like so:

Screenshot 2023-04-27 at 11.11.44 PM.png

 

LEFT(
  Name,
  FIND(
    " - ",
    Name
  )
)

See Solution in Thread

Nathan_Ramey
6 - Interface Innovator
6 - Interface Innovator

I fixed it all I did was add a "-1" to the formula

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

Is there a seperator of some sort?  If there is you can use it with LEFT() and FIND() like so:

Screenshot 2023-04-27 at 11.11.44 PM.png

 

LEFT(
  Name,
  FIND(
    " - ",
    Name
  )
)

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?

Nathan_Ramey
6 - Interface Innovator
6 - Interface Innovator

I fixed it all I did was add a "-1" to the formula