I am working on a long list of addresses. Almost all of the addresses have have the city at the end (like "1234 Main Street CITY"). I am wanting to remove the CITY from the address field for a vlookup that we do. There are two problems to this.
1. CITY isn't always fully spelled out (sometimes it's CI, or CIT)
and 2. Some of the street names contain the CITY word (so like 1234 CITY Street CITY) so a search and replace won't work.
The only thing they have in common is they are at the end of the text.

So... is there a way to search for data with nothing after it? I tried looking it up and the only thing I could find was the TEXTAFTER function, but that doesn't look like it will do what I need.
I am hoping there is a symbol I an use so I can do a find a replace for like CITY% and it will only remove the ones at the end.

Thank you.