PocketListings_ - profile

PocketListings_ · Jul 27, 2021

I’m probably overthinking this, but struggling to find the right formula to accomplish the following: I have a list of addresses in abbreviated format “123 Main St”, but some addresses have numbers on the end (“123 Main St #2A”). I’m trying to find a...

PocketListings_ · Jul 28, 2021

Found a formula that works! IF(FIND(“St”, RIGHT({Property Address}, 2)),LEFT({Property Address},LEN({Property Address})-2))

User Statistics

User Activity

Extracting the last two characters of a string IF certain conditions are met

Re: Extracting the last two characters of a string IF certain conditions are met