Excel 2008 : Formula to remove consecutive capital letters from text strings

Hey JesseG123,

You have Mac 2008 Excel which doesn't have VBA included. Excel doesn't know the difference between capital and lower case letters without going to VBA.

To include the "St" you could add an "IFERROR(FIND("St",B2),FALSE) in the formula in G2.
You should also include "y" as a vowel for cities like Lynn and "Ft" for the abreviation of "Fort".

I have no answer for the AlbanyXYZ if there isn't a space in there.