Help

Removing an abbreviation from records

Topic Labels: Formulas
Solved
Jump to Solution
754 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
17 - Neptune
17 - Neptune

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
17 - Neptune
17 - Neptune

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