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?
Page 1 / 1
Is there a seperator of some sort? If there is you can use it with LEFT() and FIND() like so:
LEFT(
Name,
FIND(
" - ",
Name
)
)
Is 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?
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?
I fixed it all I did was add a "-1" to the formula
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.