Removing an abbreviation from records

[Nathan_Ramey]

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? 

[TheTimeSavingCo · Accepted solution]

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

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

[Nathan_Ramey]

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 · Accepted solution]

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