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
Removing an abbreviation from records
+9Best answer by TheTimeSavingCo
Is there a seperator of some sort? If there is you can use it with LEFT() and FIND() like so:
LEFT(
Name,
FIND(
" - ",
Name
)
)
+31Is there a seperator of some sort? If there is you can use it with LEFT() and FIND() like so:
LEFT(
Name,
FIND(
" - ",
Name
)
)+9Is there a seperator of some sort? If there is you can use it with LEFT() and FIND() like so:
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?
+9Thank 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?
I fixed it all I did was add a "-1" to the formula
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.