I am working with street names and need only the suffix returned (Dr, Blvd, St, Pkwy)
ei. Mountain View Blvd = Blvd
I attempted to go from the right to left and looking for the first space " " from the right (between View _ Blvd) to split?
in VBA if possible